Yeah I've always liked SC3 the most. I believe most of the hate is from the competitive side of things, but the single player stuff (aside from that memory card glitch) is pretty great. It's my favorite of the series for that reason. If they ever did some sort of re-release with both versions (console and arcade) I would buy that in an instant.
Also just wanna mention how much I hate 4, since I was recently playing that again. It is such a downgrade from 3 (in terms of single player stuff) in just about every respect, from that bland "Story Mode" to the character creation (which removed the unique movesets from 3). Tower of Lost Souls is also absolutely awful and so are the guest characters (both the Star Wars characters, and the crappy anime ones).