I like me an alls-well-that-ends-well story tbh
I loved it a lot!
The misunderstood villain trope has always been a core concept in FF games and you shouldn't exclude 14.

We did have Athena last expansion though? She was evil just for the lols. I loved that too.