I (obviously) don't agree -- there are some real gems out there. If you haven't played any of the Cheshire Cat horror arcs in COH (my personal fav is Signal::Noise), or Talos Vice, or the really quirky Audition (an acquired taste, but still amusing... especially if you're a Stanislaw Lem fan), or any of my arcs (trollface.jpg) or a lot of great stories and authors I'm forgetting, you were seriously missing out. Official COH content (except for a handful of storylines) wasn't that well-written, so in fact much of the user-provided content WAS better. More importantly, there was an absolute insane amount of it -- even if I accept 99% of it being crap, there were still 6000 story arcs out there that were worth playing. That's over 6000 hours of playtime!
I find this figure incredibly difficult to believe. Mostly because even if there were 6000 missions worth doing, I CANNOT ACTUALLY EQUIP 6000 PIECES OF EQUIPMENT.
So, as far as I'm concerned, I seek only one thing when it comes to content in an MMO: "In what way does this content provide me with the opportunities or resources to murder my opponents?". If it cannot do these things, then it is useless. In STO, this is where much of the Foundry fails: It does not provide me with an efficient means of acquiring the resources and equipment I need to murder my opponents, nor does it provide me with any actual opponents to murder.
I play MMOs to Murder Things, preferrably those other people who piss me off with their irritating and repetitive breathing. If this isn't promoting my murdering, then I may as well be in SINGLE PLAYER.