My current favourite Visual Studio theme is Brad Wilson’s Dark Visual Studio. It is not too gaudy, uses a nice font (Consolas) and is easy on the eye.
For pre-Vista/Win 7 PCs you need to install the Consolas Font Pack for Visual Studio from Microsoft.
Other Visual Studio themes can be downloaded (or designed) from the excellent studiostyles.info website.
Brad Wilson's Dark Visual Studio