I played HoMM2 and (even moreso) 3 a ton. I loved the tactical combat and that resource management didn't get out of hand. I played a ton of user-made maps. Loved it.
The other two games of this genre I played a ton were Civ1 and Civ4.
I can literally recall waking up at noon, starting up Civ1 and then looking out and it was dark. I didn't really play Civ2 and Civ3 as much. They just added isometric view and even more micro-management (IMHO).
But that all changed with Civ4. It still had the stack of doom problem but the solution added in Civ5 (one unit per hex and hexes were also new) I found to be just annoying as it forced a dance to get units placed. Plus once you got ranged/siege units to range 3 I felt like it was game over.
Anyway, the big thing that kept me on Civ4 wasn't the base game it was a player mod called Fall From heaven 2 [1]. The depth was amazing. I'd really hoped they'd make a standalone game or a new version but I believe the creator now works at another game company.
So I never liked RTSs. To me it was a different kind of game that focused on APS (actions per second). It's just not my scene.
But turn-based games like HoMM and Civ are so rare these days it makes me sad.
[1]: https://forums.civfanatics.com/threads/mod-fall-from-heaven-...