I have both EZ Drummer and SSD Platinum 2.5. SSD gets you a mastered sound "out of the box" with minimal fuss.
EZ Drummer takes some work (at least for me) to get good drum sounds. I'd rather be jamming over SSD than tweaking my EZ drums.
Depends on what you want to do really. If you just want something to lay down some ideas without much fuss, some of the more polished-straight-outta-the-box stuff might be better for you (even EZD and the stock Avatar kit in S2.0 aren't exactly raw, but not like SSD). If you want more control over the sound for proper home recordings and stuff, the more flexible (and time consuming) stuff like S2.0 and its expansions might be better.
I prefer the latter. Mind you, once I got my head around S2.0 it was a lot less work. Basically saved some presets I set up for projects I was working on, and now I just load those up when I want to work on something. Change kit parts around where necessary, tweak the sound as I go along and discover where it needs something different. But the majority of the work is taken care of when I load the preset, unless I'm going for a wildly different sound to anything I've done before... which doesn't happen very often anyway.
There's also the producer pack thingoes you can buy for bugger all that'll let you just load up entire setups, processing and all. The only one I've got is the Sneap pack, but I'm not even really a big fan of his work. I got it more out of curiosity to see what kind of stuff he came up with using S2.0 (and for a few bucks, it was worth it I think). He does a lot of interesting stuff like having kick drum layers that all take care of different parts of the sound, including one that's so heavy butchered by the envelope section and processing that all it does is provide the tiny little "metal" click sound at the beginning of the strike. I don't actually like any of the presets at all, but there are some interesting ideas in there. :lol
From memory there's also some separate product they've got now that I think is just like a normal insert plugin you put on a track, and you can load up presets for guitars or vocals or whatever. No idea if it's any good or not.