I… Don’t hate this. He meets Kirk too, which could be captain wish fulfillment. After his nephew is killed in such a stupid way he just exits reality and never returns.

First Contact, like you said, is revenge on the Borg and saving Earth.

Insurrection is then him inventing the perfect woman to save and finding the fountain of youth.

Nemesis he fights an evil, young version of himself, which has gotta be worth a few years of therapy.