My Oblivion character just became a vampire, and I reloaded...

I haven't played a vammpire in a TES game yet, and don't know if I want to. It seems it would break a lot of your quests since people will become hostile towards you?

Those of you who have played vampires (both those who like it and those who don't), what's it like to play a vampire in TES?