I am pretty sure they are rather lack luster, unfortunately. The 25 pts worth of banner is hardly ever going to push them into a good place (Most don't really matter), and their killing power is nearly on level with zombies, hardly better; Nor is their survivability that much better, and the option to take spears actually makes them worse in most cases! They have armor you'll almost never be making a save with (Maybe 6+ sometimes) and can parry in combat for another try at 6+, but with 5 zombies per 3 skeletons I think the zombies are in a better place.
Both units will be doing nearly the same thing, almost always delegated to simply tying up units, never really as something you expect to be winning combats.
The 'Fear Bomb' combo, or just Screaming Banner even, is also less effective with skeletons since instead of swapping the opponent to a 5+ to hit, they'll still be on a 4+, which isn't even that much of a down grade most of the time, and not worth the effort/risk; You really want that on any WS3+ unit (A BSB Vamp can go in a ghoul unit, which could work well).
I actually haven't tried out a Master of the Dead Necro yet really, perhaps with that (Being able to raise skeletons past their starting size) they would be better, but I don't even know? Another thing that can help out Skeletons quite a bit is if you throw a character in the unit that has the Cursed Book; The Debuffs from the book often help win combat in some way (Mostly negative stats, WS/S/T are prevalent), so that could also make a unit of Skeletons more effective/a threat for opponents.
Certainly they'd never be able to go toe-to-toe with anything past the region of other poor Core Choices though, and many armies include units that out class them by quite a bit: Beastmen Gors, Lizardmen Saurus, Any Demon Core is impressive enough.
But then again there are also many armies I haven't played against yet, and perhaps their are units that the skeletons do better against in those armies (Skaven can't put up that much of a fight can they?). The best idea is to try it out at least, especially if you really like the idea/hobby aspect of the Vampires. Just proxy your models with a friend or some such, and give it a few goes if you can.
Hell, maybe you'll find a good way to use them that people haven't really bothered to try yet, or just a personal play style that works for you. Skeletons probably could work alright at least, but they would need some heavy magic support (Hexes/Augments, and plenty of IoN) to not be trampled all over. Plus they do give up a bit less combat Rez than zombies.. it's just that zombies usually annoy people better.. for less points. And Ghouls just have more attacks (Always a good thing) and poison, which is apparently really helpful, although I think they are fairly useless; Best thing about them is just filling in points once you get to like, 3k+ points so you don't have to field over 200 models to fill your core choices lol.
Anyhow, the point is, the best idea is give it a test run before you jump into anything, unless you want to play the game based on how the models look alone/story line. The armies get remade, sometimes for better sometimes for worse, and even Erratas can change the balances of the game a bit at times. Although I started nearly 5 months ago, and I still don't have a very firm grasp on all of the VC stuff yet (With at least 2-ish games a month), so I mean, mastering an army or finding the right 'fit' for you tactically could take a while, but that's true with any army. Just give it a go, and don't forget you're in it to have fun (Hopefully), so don't let stupid stuff get in the way.