That sucks. <img src="/ubbthreads/images/graemlins/disagree.gif" alt="" />
I've never been able to get into multiplayer RTS games for that very reason. I can't get a grip of war tactics and once I start falling, I can't get up again. I've played FPS games with a little more success, but still competative multiplayer isn't my forte.
There are two games that I absolutely love in multiplayer, though. The main difference is that they are co-operative.
Neverwinter Nights is an amazing multiplayer experience. You play co-operatively, and, especially if you are within talking distance, the whole experience of the game changes. You start playing the story and assisting each other instead of selfishly sending each other to your deaths. There are always noobs playing this game, but aside from that, more experienced players will gladly take along a noob and help them learn the game.
Drug Runners is a great, free, on-line game. It's not a new idea, growing and selling drugs, but there is so much depth to the game while still keeping it simple. Players fall into "cartels" of 50 members and you assist each other. Some grow the drugs, others sell them at high prices, some are better for defense and storage, and some are the muscle for retaliating. The game is still competative, but there is so much co-operation involved that it is worth it. There are new players all the time so you can always find people of your level to play with.