Myers' difficult personality caused his career to tank
He was on WTF Podcast with Marc Maron, who brought up Myers' reputation for being incredibly hard to work with.
Dana Carvey, for example, won't even work with him anymore because he allegedly took lines that Carvey ran past him for the part of Garth. Lo and behold, guess what Mike Myers' "adlibbing" lines were a carbon-copy of? He literally stole a lot of the adlibbed lines from Carvey, who's still angry about it to this day.
Beyond that, he almost lost the entirety of the Alice Cooper scenes from Wayne's World because he wanted to hold out for the song "School's Out" instead of "Feed My Frankenstein." After a lot of hostile back and forth, Cooper's manager threatened a breach of contract suit, and Myers finally caved.
This wasn't even figured out during pre-production, this was literally during the filming of the project.
I could go on, but there's a reason that he eventually had to cast himself as Dr. Evil, Austin Powers, and Fat Bastard. The guy had Liz frickin Hurley in the height of her career, and alienated her by treating her like shït on the set of the first Austin Powers.
So if you're wondering where he went, there's your answer. His career today is limited to Shrek, and even that's seriously flagging as a franchise.
The lesson to learn from all of this: Lots of people can act, write, produce, and direct. Nobody is so special that they keep a career after behaving like an egomaniacal crybaby.