Look at the title. I wanted to play a vampire but I really hate how it f****d up your face in Oblivion. So does it cripple your appearance and is your face being reset to a preset when you cure it again?
I haven't looked for the cure for the character I am playing as a vampire (probably wont for that one, I like it), but I doubt it resets your face to a preset (after all the time I spent on it it better not).
There are some minor cosmetic changes to the face - the eyes change, skin gets pale and you get some nifty fangs, but nothing drastic (looks quite good on some characters).
It gets a bit more severe the higher your vampire level, but again never monstrously bad (the scary Skyrim vampires come out of it much better then the civilized Imperial vampires, irony) . Just be warned:
Spoooiler:
Vampires here have vampire levels 1 - 4. The higher the level the better the bonuses and the worse the penalties. You naturally go up in level by
not drinking blood.
Socially you're fine for the first two levels, people are a bit negative at the third level but at level four most everyone will try and kill you until you drink some blood and go back down some levels, as this is when you look your most vampiric.