If the vanilla look of Visual Studio doesn’t do it for you, check out studiostyles.net. Here you’ll find a huge amount of visual styles for Visual Studio 2008 and 2010.
BTW: my current favorite theme is Desert Nights Reloaded 🙂 – even though I doesn’t make use of my beloved Envy Code R font …