MaxCiv
Warlord
No, I'm not particularly Steam-averse, and in fact I'd rather have Steam-based DRM than have to play with a disk in the drive. The problem is I don't trust my own hard disk. If I ever have to reinstall I want a physical CD to reinstall from. I don't want to have to download the game and possibly buy it again if I've lost some critical piece of information needed to establish my right to download it.
Once you have the game installed, Steam allows you to make a backup copy of it and span it across multiple CDs or DVDs if it's big enough.
To restore a game, all you have to do is have the Steam client installed and then run the executable that was created with your backup file. As simple as that.
I currently have 53 games in my Steam account and they are all backed up that way so every time I rebuild my machine don't have to redownload 40+GB of stuff.
You can also use the backup to install the game on multiple machines. Very convenient.