I have not seen the need to sleep in my game. I'm not sure it's not a bug for you. I really did play a vampire for a Sim week and I never saw this. I finally got him to prime vampire before I went over to my other households to incorporate them into his story. He hibernates sometimes (per my command) but he is not sleepy. Is any other vampires putting spells on your vampire? One did in MyShuno on my Sim when he tried to mind control it must have back fired and he was the one who had to remain in the middle of the street under a curse/spell and couldn't move for a very long time. But I figure the other vampire put it back on him. lol