Queen of the Demonweb Pits has a pretty epic plot, even if -- as a whole -- the GDQ story is wafer-thin as plots go.
Of course, Lolth isn't actually behind the giant attacks, so killing her feels more like high level murder hobo stuff than it does taking the fight to Thanos -- "I bet he's got more cool stuff than just that glove," said no Avenger.
Not sure I'd call it an "epic" plot though. The giants are attacking Geoff? Sterich? Good grief it's been far too long since I read/played those adventures.

If they aren't stopped, they will ... destroy a town or two. Again, totally bad, but, not exactly epic scale. Even if the Drow win, it's bad for Sterich, but, again, not an epic scale event.
Now something like Age of Worms, or Savage Tides from Paizo? Much more epic in scale. It is funny though that Savage Tides actually leaves Greyhawk (Paizohawk) behind halfway through and heads down into the Abyss. Only the first two or three modules out of the 12 actually occur in Greyhawk. I'm not familiar enough with Age of Worms to comment on that one.
My point being, by and large (and yes, I'm sure there are exceptions) Greyhawk fits S&S aesthetics better because most of the iconic adventures for GH have been very local in scale. And even the "good guys" tend to be a lot less good and more just ... people. Think about it this way, look at the starting towns in GH modules - Orlane (Cult of the Reptile God), Saltmarsh, Hommlet - none of them, as I recall, have a strong good aligned church presence. I might be blanking on details (this stuff is dredging the depths of my memory) but, by and large, there isn't a "good" patron for the PC's in the starting adventures.