Teamwork, in any team based game, is always a big bonus, nearly a necessity. Of course, many games have a much more 'arcadey' style to it, that really lowers the teamwork requirement needed, as well as the tactics and strategy, in order to help facilitate the 'hero' illusion. Games that are usually 'fast paced' won't lend well to real world tactics. At least, not in the medium that I think you're talking about.
Squad tactics work best in games that are First Person Simulations. The closer the simulation, the more valuable those tactics become. As soon as your First Person Simulation becomes a First Person Shooter though, those tactics become less and less important. You take 6 torso shots and live, still able to shoot straight, go and hide, and your life regenerates, allowing you to keep rushing forward... Sort of defeats the purpose of covering fire, doesn't it? Something as simple as covering fire has little place in your standard FPS, as they don't fear the bullet. Even if they do die, they respawn in 10-30 seconds. Big deal.
So, for most games (especially the competitive ones), no, real world small squad tactics won't work. They CAN be modified a bit to help, but those modifications will need to be made seperate for each different game and how they play.
Real world STRATEGIES, however, DO work for all team based games like that. Working together without the lone rebel doing his own thing, Set micro-objectives to achieve the overall objective, striking as a solid unit at an enemy's weak point, etc.
Tactic is how the person or unit fights. Strategy is how the entire army fights. There's a lot more to it then that, but that works for a quick explanation.
So, there's your answer whether you're talking about tactics (like I think you were form your first post) or strategy (as it seems everyone else thinks you're talking about.). Either way, I hope I've helped in some manner.