Honestly, the type of story that resonates with me the most, are the ones in which the "hero" loses. That may sound downright evil and bad, but let be explain. Realistically, at least for me in this case, I've had moments in which I've done the right thing and lose either way. Usually when this happens I question if I was really doing the right thing this whole time. The goal of these stories is to teach you to stop doubting yourself and don't give up. Something I still haven't completely conquered. They show you how a loss isn't the end.
For now, while playing Fire Emblem, I've seen this type of story being played out in one of the routes of Three Houses. Arguably two. I'm hoping while I continue playing more Fire Emblem, I may continue seeing this type of story being told.