I think for me, the big space RTS has always been Sins of a Solar Empire.....sorta. I've never actually played it.
What I have played are two amazing total conversions, Sins of the Prophets and Star Trek Armada III:
Can't find newer trailers, but both games are about a decade later on then...