Other than the old Falcon 4, there really haven't been any awesome flight sims for years...
Lock On:Modern Combat was pretty cool, but if you wait a couple of months there's a new Tom Clancy game coming out called HAWX, which is flight sim based and looks incredible.
Tom Clancy's HAWX | Ubisoft
These are actual game graphics
