I'm no SEAL, but I know that when I decide to look through my scope/down my sights, the gun doesn't automatically "snap" to the nearest enemy. Also, I've never been shot, but I assume that if I ever take three or four rounds of 7.62 to the chest, I'm going to need to do something other than drop back behind cover and wait about 20 seconds to just get over it. FPS games are a lot of fun, but you're not going to learn anything about tactics from them. If you wanted to make it real, you could always do this: if you get hit while playing CoD, go stick your finger in a light socket and don't play again for a month while you recover. If you get killed, do the light socket thing again, but this time take your X-Box outside and burn it.
I think the only game that might teach you a thing or two about tactics would be that America's Army game that came out a while back. IIRC, it was developed by the Army to help drive home small-unit tactics; how to position yourself and your squad to keep from getting killed. That game got a little old, though, because it was too realistic. You had three guys, and if one got shot shot (which happened often, if you're not a Marine Corps Staff Sergeant...) you'd have to carry him to an aid station; which meant the guy doing the carrying was sloooooow, and couldn't shoot. And naturally the aid station was about ten country miles away!