So how is Xenosaga?

There's this revelation at the end of the third one. I'm still trying to decide how it stacks up compared to the bit at the end of Yakuza 7 and the big twist from Bionic Commando.