Lighthearted? Well, that can be good. However, there is nothing but gameplay to hold the player in. A few too many deaths or long levels and the player will just give up. Nothing will keep them hooked.
As for dark... if it has angst, make it justified and make sure angsty characters never win. The minute an angsty character saves the world, it becomes evident the story was written by an angsty teenager looking to take his anger out on the innocent players.
Funny? Well, if you can keep the player laughing, this will work. If you have one good joke every ten annoyingly hard bosses, it just ends up boring.
Dramatic can work, but only if the events can really touch the player. Too many storylines end up having the player say "wait, who just died?".
Action? Alone? Unless your gameplay kicks infinite... pass... the player will lose interest soon.
With complex, make sure any info given is relevant to the story, and, therefore relevant to completing the game. If a player who can't read can beat the game, your storyline sucks.

That said, I side with "whatever you think won't suck".