F.E.A.R. Combat: the free version downloadable for MP purposes. They basically took the MP part from the full SP/MP game.

Besides that one and the other ones mentioned here, I'd have to second CoH, simply because the setting alone makes a person immerse into it. It's one of the best RTS games I've ever had my hands on.