Your experience with the Pathfinder Society games mirrors my own during my involvement with the Living Greyhawk campaign that Wizards ran for the better part of the last decade until they replaced it with the Living Forgotten Realms, though aside from a change in rule sets, the look and feel is very much the same. They're tournament-style games with timed adventures and parties of players that have mostly never played together, so the chances for good storytelling and roleplaying are few. In fact, you'll typically get a player or two that wants to push things along if things seem too bogged down, given that if you don't finish your adventure in the allotted time, you'll have missed out on XP and rewards. This feels exactly like a WoW pickup group, which is one of the reasons that I lost interest. Why would I drive across town or even across the state to partake in the little gaming cons that run these events when I could get the same experience staying at home.
However, all this does is really shine a light on the importance of a good gaming group and a good DM. This isn't an indictment of the tabletop hobby any more than a bad CRPG or MMO means that they're all not worth playing. But the greatest strength of games like D&D is also its greatest weakness, in that you're only going to enjoy the game as long as you've got people you want to play with and a DM that clicks with the rest of the group. I think that until we had widespread availability of CRPGs available that anyone who wanted their fantasy fix just had to put up with whatever players and DMs were in their area, and I've talked to folks who love CRPGs but hate tabletop RPGs, only to find that the reason they hate it is because they had some truly horrible experiences at the hands of DMs or their fellow players, and assumed that the games just weren't for them.
Still, it doesn't mean that the only good tabletop RPG is one that's full of drama and well-developed characters, or that CRPGs can't deliver as good or better of the same. Just as there are roleplaying servers for MMOs, there are tabletop groups where more or less roleplaying is the norm, ranging from intense, detailed character-diary keeping and scripts that the whole group writes out (yes, I've seen and done it) to groups where, unless you're playing an optimal build in the optimal fashion, you're just not going to fit in with the other wargaming grognards at the table.