Xenogears is one. It opened my eyes to what philosophies are worthy of pursuing in life, and what other ones are objectively destructive to believe in (embodied by Karelian). It also opened me up to God from a strictly atheistic position. Mother 3 is another one.
By the way, the way you say action/adventure games have "aesthetic" is hilarious. You're no different from retarded 70s comic book fags who thought the "bad guy designs are so cool! T-the aesthetic here is genius!" You act as if they have the aesthetic of a Monet painting, when their aesthetic is closer to that of a retarded comic book. If the "aesthetic" of action adventure games is as good as it gets for you, well that's just sad