I'm a big fan of the Dragon Combat overhaul mod, I think it makes dragon fights appropriately challenging. It doesn't modify dragons through stat manipulations and buffs, just gives them a lot better combat AI, making them exploit vanilla dragon attacks they would otherwise almost never use, makes them faster on the ground, and most importantly dragons flying overhead, landing nearby or taking off nearby have a real weight and power to them, enough to knock you around like the puny human ragdoll you are. Protip, don't fight dragons near cliffs or high ledges.
The Civil War overhaul is buggy as fuck for me however, I can't seem to get beyond the jagged crown quests for either side before the whole thing starts bugging out, giving out quests for the other side, mixxing up Legate Rikke with Ganmar, sending you to attack areas that don't update the quest, etc. I gave up on it for now, maybe after a few versions it'll be more stable.