This is a tad difficult to answer, since I've been playing RTS games since I was 7 or so, but I'll try. StarCraft is a bit dated by now - there's a lot of micro involved, and as such the learning curve might be a bit steep. It's still a great game, though, and you can't really go wrong with it.
You might want to try WarCraft 3 (and its expansion, of course) - it, unlike StarCraft, features a lot of little things which have become a standard for the genre, and while there's still a lot of micro involved - despite the addition of auto-cast for certain tedious spells - the scale is smaller than StarCraft's, and should be more manageable.
The first Dawn of War is also a good starting point. While not as different and/or innovative as I'd wished it would be, the squad system nevertheless cuts out a lot of tedious micromanaging, although there will still be a lot going on.
DoW2 is a very different game - it's more of a real time tactical game, and of a much smaller scale. Interestingly, DoW2 can be said to venture into action game territory - there's a lot going on, but as you rarely control more than a handful of squads, each being highly specialized and capable of devastating the rock to their paper in moments, you never really get overwhelmed, and so it often comes down to fast decisions.
I'll also add Supreme Commander while I'm at it. Huge scale, brings computers to its knees, and some very clever solutions to reducing in-game chores. Other than that, however, it's a fairly traditional RTS, and you're probably better off with a Blizzard game to start with if you want to ease yourself into the genre.
The early C&C games are intuitive enough, but I'm not sure how difficult the campaigns are. You should probably stay clear of Sacrifice, as it controls like an RTS but features a locked camera that can take some getting used to. And, of course, for "unusual" there's Hostile Waters: Antaeus Rising, which is an action/strategy hybrid.