One I recently remembered that's worth the mention is
Battleships Forever: Free RTS game. It once had a huge cult behind it, until the devs just decided to forget it existed and refused to pass on the torch to the several thousand acolytes at their disposal. It's an RTS that focuses around small tactical missions rather than large, resource oriented wars. You only have control of a few ships, but each one has their own specific purpose, with their own special abilities with a massive focus on positioning. Your battleships are fitted together using a series of pre-determined weapons, armor, and modules, which all can be individually targeted and destroyed. Your heavy beam battleship does really well against slow enemies, but it turns slowly and is easily taken down by a couple weak fighters that can just avoid your death beams, so it's in your best interest to defend its flanks. That boss you're taking down has some major shields on the front, but the modules for those shields are actually located in the back, with some visibly weak armor protecting them, so it may be in your best interested to surround it and shoot its ass. You can usually pick and choose what ships you get each mission, so you can design your own strategies. It also comes with a mission-creation system and a system to make your own ships. There are thousands of homebrews on the internet, but they may be harder to find now that the game has become extremely obscure. Cosmoteer is a more modern version of this game, with a lot of the core ideas originating from Battleships Forever.