The Dunmer vamp looks pretty cool. The game does lighten the skin tone when you become a vamp but it doesn't look weird. Here's a sample video showing a Dunmer vamp:
I have male Dunmer vampire and the problem is that the red on his cheeks looks like he is deceased, very disappointing. Don't know about the others. This is my perception, of course.
I love my Dunmer, though I had to use an appearance change to make her skin as dark as possible. Now she almost blends in when in stage 1, but still looks badass in stage 3 and 4.
I think the prominent cheekbones and arched brow help the Vampire look substantially.
If we're talking about stage 4 vampires, I'd say Khajiit only. Blows on any other race.
For level 1or 2 anything can go, it just makes the character dead-pale with red glowy eyes, which can be really cool if it's the kind of appeareance you're looking for.
(This comes from someone who loves how the khajiit look).
When I turned one of my chars vamp he lost almost everything that made him look good (his fur turned white and his stripes are almost impossible to see, he got super skinny and his eyes turned red)