I definitely think that SC2 is more about official competitive maps. I downloaded the map editor during the beta but I simply couldn't understand anything except for the trigger editor (which was horribly buggy). Most people that I know that play SC2 don't touch the custom games even if they did the opposite in Wc3.
I actually played the campaign (RoC and TFT) for the first time just a few months ago. I didn't find the story that good, but I think that was because of the way it was presented. I already knew the story and found it quite interesting when I first read it, but not when it was told in the game. As for the gameplay it was quite interesting since it wasn't all RTS (I had actually never played the RTS part of Wc3 before that). Heroes are kewl The balancing (at least at the difficulty I chose - Normal) was a bit lacking. I found myself often being able to do just about every mistake there is while still being able to win, and then at the next map I lose after 10 minutes with much fewer mistakes. It felt like some maps could be completed with any strategy while some required very specific actions. It lacked consistency in its difficulty,
I enjoyed the bonus Founding of Durotar campaign from TFT more than the standard campaigns Not a big fan of stressed strategy gameplay.
As you might guess if you read what I just wrote I play custom games exclusively. Mostly hero games (Angel Arena, Gladiator, RPGs, DBZ Tribute, Hero Line Wars, Survival games, Defense games, etc) and those with more focus on armies (Footmen vs Grunts, Blood Tournament, etc, and Footman Frenzy back when it was balanced) with the two requirements that it isn't based on invading/capturing enemy territories (like Coming of the Horde). I used to play a lot of skill based games (I was great at Warlocks) and platformers/escape the X games, but after switching ISP I can't handle delay reduction anymore for some reason.
And I try to make a lot of World Editor stuff. Mostly refining completely useless GUI triggers for months to then lose all my work because I forget to backup and my hard drive decides to break/corrupt Windows. I worked together with one guy to make Illidan's Challenge (don't think it is called that anymore though) that ended up becoming quite popular for a few weeks. I made some horrible code that I just want to tear apart whenever I play the map now