I'd say no.
The campaign is very fun to play, the best designed campaign in any RTS yet, but the story is absolute trite, especialy compared to the prequel's one. It doesn't look like you care about that though.
When it comes to online multiplayer, it's nothing special. I've played it for about 4 months, it was fun, but no more fun than any other RTS like Red Alert 3. In fact, I found RA3's multiplayer more fun than this one's (RA3 is a good game, but nowhere near e-sport material). My problem with it is that the game is built around hard counters, whereas Starcraft 1 was all about soft counters. You make the units that counter the other guy's units, you put them in a ball, and you atack move into the enemy. Especially as protoss, even in the start when there was no master league yet, I got rank 1 diamond just by waiting till I have a few colossi (boring a-move units that barely require micro), then taking them and my warpgate units, all selecting them in one or two control groups and for the most part a-moving into the enemy (and force fielding a bit, wich is really easy, requiring no skill).
Starcraft 2's units just require so little input, it makes the games boring to watch. I sucked at Starcraft 1, I didn't know how to play at all (and it was still really fun to play), yet the pro games were so much fun to watch, there's so much going on, and even though I played Starcraft 2 myself, and watched the pro games to get better, they were so boring to watch, because there's just so little going on.
My problem with Starcraft 2 is, it requires so little skill, for the most part it only requires for you to know the best build orders, and you get into masters easy when you do.
Don't take my word though, go to teamliquid.net, wich is the biggest starcraft fansite, and search around in the starcaft 2 section, you'll find very detailed threads written by starcraft 2 players that analise why Starcraft 2 is so lackluster both to watch and to play, especially compared to the prequel. I can give you links if you want.
I kid you not, if this game wasn't the sequel to Starcraft, it wouldn't nearly get the attention it's getting now, it would be written off as just another good-but-not-great RTS.
TL;DR: it's a good game, I had fun with it, but it's not nearly as fantasticly fun to watch and play as you're led to believe. It's not the second coming of e-sports, many SC2 pros agree.
I'd sooner recommend RA3, wich is not amazing by any means, but is slightly more fun and requires more input than Starcraft 2. That or Starcraft, wich I found very fun even though I sucked at it and only played 2v2s-4v4s.