Notable "modern" RTS games are -
Command and Conquer 4
Company of Heroes
Dawn of War 2
Men of War
Red Alert 3
Shogun 2: Total War
Starcraft 2
Supreme Commander 2
World in Conflict
As for which ones are good, it will be subjective, especially since the genre is more broader now in terms of style. Company of Heroes, Dawn of War 2, Men of War, Shogun 2, and World in Conflict for instance play much more differently than compared to "traditional" RTS games.
Remove CnC4. The only way that game is notable is how fucking horrible it is.