I mean do I even need to say it...
Starcraft: Brood War. Compelling single player campaign and story (wow, you can make a meaningful story with just dialogue boxes, AMAZING, you don't need all this CGI shit). Multiplayer ladder was intense, multiplayer custom games were a new exciting concept that they fucked up in their sequel, and its replay value has no rival compared to other games I've played.
Other games I can play for hours still, Civilization III, Sins of a Solar Empire, Rise of Nations, Age of Empires II, Sim City 4/Cities Skylines, CounterStrike series, Elder Scrolls Series (even oblivion if I'm super bored), Shogun 1&2 Total War, Red Orchestra series, and I'm sure I have others but can't think of them, oh yeah Superpowers 2.
You can see the theme here, I enjoy RTS and FPS games for the most part, but I enjoy the occasional TBS and sandbox game. The most enjoyable kick I get out of an RTS game is like a slow build up like those boring sci-fi genre films, then that moment when everything is chaos and you have to sort out priorities and create a good timing and combination of units. But then why would I hate a game like Dota 2/LoL? It's so draining and boring as a game. It feels more like an arcade than an RTS with one unit, because you're trying to farm the most gold and you're trying to get the most items so that you can get the most kills and glory. That's all it really ever is it seems. Sure they ask for teamwork on a professional or friend level, but when you're not playing with a team not only are you competing with your own team, you're trying not to die to the other side. So fuck MOBAs.