...And we have our first response in the other direction (that video games can have some indirect benefits on real life performance). Now I'm worried again, because I know absolutely nothing about FPS games. Really general skills though I've probably acquired, since I'm quite good at video games overall, just never found the FPS games attractive. Part of the reason is that I was never interested in guns. (I wouldn't be surprised if I'm the only one on this forum who was like that). Even on the day I did my handgun safety class, I pretty much only recognized two kinds of guns...a "black gun" or a "silver gun".
Naturally, I've moved beyond that stage since then.
Someone should make an analogue of this thread asking the same thing about paintball, airsoft, or lasertag activities. I can't be the one though, since I've got less than zero experience with those, so I wouldn't know how to structure the poll or raise the question.
Don't worry about your skill or lack thereof when it comes to video games. My old man could shoot the nuts off a gnat, and he hasn't picked up a controller since we used to stumble through Contra on NES when I was about 8. Your skill with a real firearm will pretty much be determined by how much time you spend shooting it. You can accelerate the learning curve by finding some knowledgeable guys to show you how it's done, but even so, you'll gain skill by putting rounds through your weapon. I think that there is some value to paintball/airsoft training, but it doesn't matter how tacticool you are with an airsoft gun if you can't get hits in real life, with your real gun. My advice is to get a solid handle on the basics of marksmanship at the range, and worry about the tactical stuff later. Being intimately familiar with your gun is much more important than all the other stuff. You're never going to be stacking up on a door with five other guys and clearing rooms against a hostile force, and if you look into most defensive shootings, you'll start to see that it's not going to be a firefight; it's going to be pop, pop, pop, fight's over-one way or the other. Survival will depend on you being able to get your gun into your hand and ready to fire as quickly as possible, while 3/4's asleep, in your underbritches, in the dark, scared s**tless, with some meth head either kicking in your front door, or standing in your bedroom with you.
TLDR; Gotta get solid on basics before you go advanced. Take your gun out and shoot the hell out of it

, and worry about the other stuff later. Once you've established the basics, you can take off the training wheels and then spend hours practicing those advanced skills. The good news is that you get to do lots and lots and lots of shooting!
