Maybe they all used to be more interesting, but then they took an arrow to the knee.
I can't think of any games that put too much emphasis on NPCs. Obviously there's Alduin, Tullius, and Ulfric, but the point of an RPG is that you, the player, is the star of the story.