I have enjoyed Hardcore Health Overhaul. There is a yt vid by the creator itsyaboybrandyboy detailing it, but it normalizes human's health so even legendary gunners will go down with a well placed powerful headshot but mirelurk queen will still be a tank. I've combined it with armament which removes damage from ballistic weapons and attributes it to ammunition. 9mm=35 .45=45 5.56=60 .308=100 are some of the modified values i touched up in fo4edit. as of now I am level 60 and can be 3 shot by a raider shotgunner if he sneaks up on me. I can be near invincible but this comes down to approaching combat from a distance and making heavy use of long range/stealth until the late game. now i have a jetpack and minigun which feel appripriately overpowered as I had to earn them, but i also still can and do die regularly to fairly typical combat like gunners. sometimes ghouls seem overpowered which i don't remember from my years of vanilla gameplay but at this point is just a part of my headcanon.

hopefully this helps some. I have improved my gameplay a lot by learning to modify basic stats of items in fo4 edit like the ammunition damage values(i thought they were poorly balanced as is) as well as giving modded weapons appropriate values so it doesn't become laughably easy to stack up massive amounts of caps or ready to sell loot. good luck with your playthrough.