FS2Open (Descent FreeSpace 2)

This is one I've been chomping at the bit to try, but haven't gotten the chance to. It's been in development since 2002, and thanks to a lot of modern additions, makes the game look absolutely gorgeous.

Here's a video someone put together, that compares the original retail release, with FS2Open. It's really tasty.