As for the ending, while I try to keep my experience of the game restricted to the game itself, it's impossible for me to fully separate Final Fantasy VII from the existence of the Final Fantasy VII franchise. I know this game has several sequels by now, which means that when I look at the ending, it feels... Well, I can think that having Barret work on an oil rig is a fucking stupid decision, but while every single point of detail and characterization in Advent Children or Dirge of Cerberus or whatever may be up for debate, what their existence spells out in the broad strokes is that canonically, there is a future for these characters, there is a world after Holy. And having that outside context helps swallow the pill of the ambiguous ending, for me.