If you're already using the media vps, you'll be amazed that FS2 can look even better. Major additions are some new hi-poly models and tons of normal maps (makes the textures look more "textured").
Here's a link to the release thread:
http://www.hard-light.net/forums/index.php/topic,58230.0.html
HUGE NOTE: The thread has complete, detailed instructions, but I wanted to point out that you need to use a new, experimental build of the game engine. In my experience the newest builds are stable, but you may want to avoid them. Details in the thread.

Fantastic! I'm getting it set up right now.

Just what I was looking for - thanks a lot Cliftor :).

Just bought the game last night. Love this site, no steam, no probs, the mods are awesome, have the open source so far, I'm regrettin not givin this game a chance earlier when it hit the shelves, lovin it.

I am downloading and setting this up, finally. Do you know if there is any preferred Mac OS X nightly build?

Just get the latest nightly build for maximum pleasure.