Well, I like there to be a lot of both story content and h-content, but those tend to be rare. Most games either have the minimum story to link together h-scenes, or have 2 token h-scenes for each girl. Having to choose between them, story heavy games are better than H-heavy games.
As for what kind of content in the games, I guess comedy > action > suspense, but I've played good games of most story genres.