It's almost the wrong question. I think the issue is more "structured/railroad" versus "player driven/sandbox" campaign styles.
There are many different questions in Good v. Evil opposed to Swords & Sorcery:
1) Party alignment and motivation. Are they good guys whose motto is "Truth, Justice, and the Gondorian Way", or just low-life scum looking for something to steal who say "Who Wants to Live Forever"?
2) Non-dungeon NPC motivation. Are there lots of mostly good PC's to defend, people who make themselves worth saving -- in my wording, is there a Shire? Or are all NPC's just jerks trying to steal from the PC's, assassins in disguise, or at best props to be kidnapped to "motivate" the PC's to action?
3) Is there a plot to the campaign? Are adventures a bunch of mostly unrelated stuff, perhaps with some recurring themes or villains, but no overall story arc (like Classic Trek)? Or is there a story arc from beginning to end that the DM has planned out (like Babylon 5)?
4) Is there more than one enemy, or just one uber BBEG behind it all?
5) Is the choice of episodes/direction of the plot primarily DM-driven ("after the Dwarven Hall, they'll need to deal with the dragon threat"), or completely free-form player driven ("we don't care about the Realms anymore -- let's teleport to Mystara this week!".
6) Is the purpose of the campaign 'save the world'? Will the PC's go through the Adventurer, Conqueror, King, Godling cycle and become superheroes in the end to complete the plot?
7) Who's the best fantasy writer ever? Tolkien or anybody else?
My preferred answers are usually: (1) Gondorian, (2) there's a Shire, (3) episodic only retconning an overall plot, (4) multiple enemies, (5) DM picks/writes the adventures, (6) stop at a level lower than "top" and with a final plot where it's not down to the PC's to Save All Mankind, and (7) Tolkien.
Others, obviously, prefer other feels, and I bet most people mix it up on these issues in different campaigns.