As far as realism then CoD4 is probably the best. However, I prefer the look of the id Tech games (Doom 3, Quake 4, Prey) because of the sharp dark shadows and no overuse of bloom (and I can play them on my PBG4 ). I also think Colin McRae Mac is fairly pretty on highest settings. Even if it is a little old.
WoW is a pretty game too without being taxing on hardware which I think is awesome.