IMO, not really.
SPOILERS
He went crazy because he found out he was genetically created with Jenova and was a "monster" and then read up what Jenova and the Ancients was and created this narrative that he's Jenova's son and should do her bidding by greatly harming the world and then use it as a vessel to conquer other planets.
Only he was defeated and then fell into the Lifestream where he gain massive knowledge about literally everything but his plan was still unchanged. With the knowledge that he really isn't Jenova's son he still wanted to do what she wanted. His goals and motivation is dumb. In a way, he was mentally weak.
---
Don't like it? Don't watch it. It's that simple
Dictator of Nice Guys
... Copied to Clipboard!