Would you like civ5?
I have no idea, because mostly, no one knows exactly what civ5 will actually be like.
It's bizarre to me though that you like HoMM2 and 5, but not 3. Maybe you just never played it?
I also hated AoW, eventually, because it was just pointless after a bit, but I'm told people like it for MP, which I guess makes sense, I cannot fathom enjoying the SP after you learn the mechanics of the game because it becomes too tedious and simple.
GC2 is another of those which I enjoyed until I 'mastered' it, and then the AI shortcomings and lack of interesting victory conditions (because culture was so boring to just spam stations, and teching is just hitting 'done' over and over) eventually killed it for me.
Disciples isn't design flawed though, it's more of an RPG in essense than it is really a TBS. The beauty of it in many respects is the smiplified combat and 'puzzle' nature of the maps. But i also grew bored with it after a couple campaigns, because it does get rather repetative.