The single-player campaigns were a major focus for many early RTS. Even Warcraft II many players mostly played the single-player, but that was probably the tipping point due to the success of Battle.net.
Eh, I'd say the campaign of WC3 was a pretty big focus, or at least Blizzard clearly considered it one since it formed the basis for a lot of WoW's storyline.