“how good” is sort of a loaded question.
Since you said traditional non-EDM, yes I would say “night and day” just based on the drum kits available for acoustic kits in anything but Groove Agent.
How deep do you want to go?
Unlike a reply above, I think Toontrack Superior is by far way ahead of anything else when it comes to flexibility and overall sound. But keep in mind it depends on your drum objectives. Also you should do a search at Gearslutz unless you want only a comparison with Groove Agent. IMO I would compare Groove Agent SE with Battery3 or 4. But it’s a different world when comparing with 3rd party drums.
I use EZ Drummer with most expansion packs and Superior Drummer with a few expansion packs. As I said, with that combination, nothing else comes close IMO. Sometimes I start a project with an EZX pack but later load the EZX pack inside Superior for further processing because I want a feature or sound not available in EZ.
Do a search. One of the best things about EZ is you can tap in a groove and EZ gives back grooves close to what you tapped in. It’s great for production ideas.
How important is drum miking for your non-EDM projects? Drum miking when applied to natural acoustic drums in any space makes a huge difference. The drum bleed options and how they relate to miking are what makes Superior so real and stand out among the competition. Look how bleed is achieved in Superiors mixer. Nothing else I know of comes close.
I think in all scenarios, EZ and Superior, you can achieve total dry unprocessed samples with the exception of whatever room, processing, and actual tracking which IMO is very minimal. With each EZX and SD pack you can read how the samples were tracked. But remember the objective of EZ is quick, relatively good, and fast so that is going to include some processing.
With Superior it’s much more powerful and flexible…even building a drum kit from scratch. If you want a isolated more dryer drum sound common from the 70s…Fleetwood Mac, Steely Dan etc…buy the custom and vintage SDX. Keep in mind you will spend more time with Superior because of the many options. Going past the kit building stage, you are dealing with a much more complete mixer with effects, mic bleed, aux’s and integrating that with Cubase. This is why some choose EZ instead of Superior. EZ has a mixer, but not nearly as complete as Superior. Clicking on Cubase’s “show all outputs” works fine with both EZ and Superior.
Superior is due for a upgrade soon so be aware of that.
Ultimately, ask yourself how easily your drums fit in the mix. There are endless demo examples for sound.