I almost listed Jacquelin Carey's Shapers from the Sundering, then remembered that they were the Valar under a different name. My mistake.

The common thread in the two I mentioned, and most of the others that enjoy, is a sense of personality and involvement. I like my gods with a touch of humanity, ambitions, goals, and active involvement. Dragonlance isn't exactly high or quality literature by most measures, but I definitely enjoy the relationship between it's gods and it's stories. The exact same thing could be said for the Forgotten Realms pantheon.

Of course, this type of pantheon, and personality-driven gods, obviously has it's roots in the Greek gods, and the greek myths are some pretty iconic storytelling.

Which is not to say that a more abstract or absent god doesn't also make for great storytelling - but it's not storytelling that's going to make me interested in the deity, because the very nature of that sort of deity places the emphasis on the characters, who are actually present and involved in the story.