So far, if I wanna have a vampire who's super powerful and whose weaknesses barely are, I go 1 point into the coffin-only, 1 point into fitful sleep, and three points into day phobia. I'm not playing one right now so I can't look up the exact names of the traits.
Day phobia will sound bad, but the only major drawback I experience is the weakened power during the day (thus difficult to compel for drinking, namely), and while the tense moodlet may seem overbearing, take 'carefree' from the aspiration reward store(costs 2k) and bam no tense moodlet anymore. I like coffins anyway and the fitful sleep I've barely noticed.
Meanwhile, something I thought would be fine that ended up driving me bonkers was the stomach/can't eat regular food one. All those invitations to dinner, all those glasses of water! It will be fun for some vampires but the ones I've been playing like to keep up appearances!