I'm probably the only person here with a large Intuos pro, but then I'm also a fringe case since I also engage in some drawing as well. It also shouldn't be problematic if you're used to swinging your arm around playing CS:GO at low DPI. I have a huge desk so space isn't really a problem.
As for which model to get, don't be afraid to look into older Intuos 3/4/5 models as they aren't worse functionally than the new ones, in fact the Intuos 3 I had once was so tough it could probably have stopped a bullet.
The only problem was that the I3 had terrible hotkeys that I never used.
The I4 was better in that it had OLED displays that showed what all your buttons did and had a nicer layout you could actually make use of.
The I5/Pro feels the best, since it's covered in soft-touch rubber and the hotkeys make the most sense. However, it's also a step back, since the top surface is no longer replaceable.