2 of the games that come to my immediate mind are Age of Empires 3 and Alpha Protocol.
There’s no balance between the civilizations or the card system, the “home city” mechanics is pointless and very half baked, but the gameplay loop is so insanely good. I’ve spent more time playing AoE3 than any other Age game.
Alpha Protocol had very low quality graphics for the time, combat was wonky, but the choices you make and the writing was top notch.
You called down the thunder, now reap the whirlwind