If you have a PC, get Medal of Honor: Allied Assault.
It came out in January, uses the Quake 3 engine (read: looks great), has tons of atmosphere, and isn't realistic

But it is damn fun, and much better than RTCW.
I actually modified the damage on the game to make both me and the bad guys a lot more fragile, and enjoyed it quite a bit.