A partial counterexample might be soldiers with ptsd. First Blood was a sympathetic portrait of a vet wth mental illness, so was_Jacob's Ladder_. Hercules and Ajax from the Trojan war are both tragic heroes despite their violence towards family members.

For a more recent example, watch Jarrett Moore's video about military propaganda, he interviews GWoT vets about their ptsd and it's very sympathetic.