DodoGeo: Did you take a look at Fallout warfare? It comes with Fallout Tactics as an extra.
The game comes with the board game on disc, all you would need are a printer, scissors and dice.
No I haven't. Thanks for bringing it to my attention.
Crassmaster: If you're looking for something that's more of an enclosed system in a box, you might want to check out Earth Reborn.
http://boardgamegeek.com/boardgame/73171/earth-reborn Solid system set in a ridiculous (in a good way) setting. Slowly adds more rules as you play through the scenarios, and then you can basically build your own 'levels' and play.
There's also Tannhauser.
http://boardgamegeek.com/boardgame/25261/tannhauser It isn't as detailed, but again has a setting that's ridiculous in a good way (think Germans seeking out occult help as in Wolfenstein). Not as detailed as ER. It has some bad reviews based on what was apparently a godawful initial ruleset, but the newer version is very good. Tannhauser also has a ton of expansion material through character packs, two map expansions and one full fledged expansion box.
Finally, Sergeants Miniatures Game.
http://www.lostbattaliongames.com/c-49-sergeants-miniatures-game.aspx#SMG-Anchor I haven't started buying in to this...yet. Definitely NOT a cheap system, but it's comparable to something like 40K. Minis are pre-painted, and if you were to buy half a dozen rifle squads you'd likely get 6 sets of completely unique men with their own ratings and sets of cards.
Thanks! Earth Reborn looks good, and may be just what I am looking for. I'll take a closer look at it later.
-edit- Damn, it looks incredibly good!
http://www.youtube.com/watch?v=OqN6EYMTKSs Watching the later bits of the video, it's still not quite what I'm looking for *exactly*, but it's close. I'm going to check out eBay later tonight to see if I can find an affordable copy of this.
-edit- I also just took a quick glance at the FOW rules. Very nice, but there doesn't seem to be anything on destructible environment (which is one thing that has me really excited for Earth Reborn).
I'm going to try a few sessions of these with my friends. In fact, if my excitement continues to grow until it bottlenecks, I may want to try creating my own rulesets and environmental designs. :D