Even in the main series he’s been switching between power hungry destroyer of worlds (Galaxy, Wonder) and goofy bully with a Peach obsession (Sunshine, Odyssey) for a long time.
Yeah, RPGs (Square, Paper or M&L) often have him team up with the good guys when he’s been out-villained. He’s particularly depicted as incompetent in those, and usually kicked out of his own castle, it and his minions being one of the rare other things he cares about.