I don't think I explained that very well. My bad. I meant as in sword/sorcery D&D-esqe fantasy rather than sci fi, horror or the like. Were there any shows or movies that portrayed a fantasy world that resembled that of D&D. I think it was a bad analogy to begin with though. I was a bit rushed and probably didn't think it through properly in my reply.
You've all given me some ideas to think about and I fear I may be over thinking things a little. I think I just need to lower my expectations a little and be more careful how I handle magic and such in game. I think coming out of a lengthy high magic campaign coupled with nostalgia for the good old days of my early D&D career may have burned me out a little.
There aren't any real sword-and-sorcery shows that aren't monster of the week sort of series. But saying that shows of other types don't allow for examples seems a little bracing.
Supernatural: Two brothers use very rogue-like skills to hunt down demons. Pretty much starting with Gathering Information, Thievery (Pick Locks, Forgery, Sneak/Move Silently), and Research along with Knowledge they track and kill monsters hunting down a fiend who murdered their mother in cold blood. The rogues gain allies amongst the outsiders who do the same, who have been fighting a battle against the darkness that has driven a lot of them to drink, depression, or loss of their own.
Fast forward a couple of seasons and they have gained access to rituals, are battling ancient forces of evil, and meet avatars and archfiends. The two brothers take very different paths, from an crooked pathed Paladin-esque protector of the innocent to a twisted, corrupted youth who has turned to darkness to battle his own fears. They have battled a hundred monsters, facing off against the Lightbringer himself. They have been raised from the dead (where they came back weaker until they got 'back into the swing', trading for power, gaining a magical ranged weapon with Bullets of Slaying... Where is this not just Guns and Rituals over Swords and Sorcery?
Angel/Buffy: A powerful female character and her older mentor begin a war against creatures. She has a unique birthright making her stronger, and she battles for Good. Through her development she takes on a group of followers who slowly diverge on their path. Due to various mishaps they gain the ability to cast spells, become a talented fighter through possession, and a few are the Things That Go Bump in the Night. At the end of one series an entire city is destroyed to save the world from its horrific destiny.
Move to the next series.... A handsome Thing That Goes Bump In The Night realizes he needs to move along and goes to a corrupt city seeking to abolish it. Taking on a young ruffian from the streets, two scholars, and an obnoxious blond-haired rogue-type they begin to fight a battle, but the demons keep coming. They make a pact with a group of Elder Forces, and the last scenes of the series include (turn volume off, it is just a stupid music video as I cannot find a better clip on short notice)
[ame=http://www.youtube.com/watch?v=vlqM3NCLRpU&feature=related]

[/ame].
1.) A Wizard's duel,
2.) an epic set-breaking fight against the BBEGs' head bruiser, and
3.) LITERAL DRAGONS AND A DUNGEON!
So how exactly aren't these like D&D? Heck, they have their own RPGs based on them

.
Slainte,
-Loonook.