Recs.
Updated
Also known as "The original X-COM", or the king of strategy games. The intro consists of a general "aliens are coming to kill us, but we will fight back with your commanding skills" plot, and then you are dropped into the world view to figure things out. Preferably before all of us are dead.
SpecsUpdate
Pros
Pro Very deep strategy
Keeping track of more than a dozen soldiers with 10 skills, their inventories (including ammo count and weight), dynamic visibility, line of sight, destructible terrain, consequences of missed shots (like friendly fire or destroyed loot), etc. quickly overwhelms noobies, putting the real strategy masters in the limelight. And this is just a battle out of many, with base building, personell management, logistics, reconnaissance, research and manufacturing between them.