I assume we're talking fairly current games?
The Witcher
Medieval 2 Total War:Kingdoms
Command and Conquer 3
Supreme Commander
Neverwinter Nights 2 and Mask of the Betrayer
I cannot rate any FPS as great anymore, they've been about the same since Quake. You could make the same argument about RPGs and RTSs, but at least in a good RPG or RTS you have a good story to go with the rest of the game. FPSs these days are all flash and no substance. CoD4, Crysis, ETQW, BF2142, Halo 3, etc, nothing but more of the same.