Anime
Maxie showed up in two episodes: "Gaining Groudon" and "The Scuffle of Legends." His whole thing was expanding Hoenn's landmass because he genuinely believed it would bring peace to the region. By the end of the second episode though, he had a change of heart and abandoned this plan entirely, accepting that Hoenn was better off as it was.
Manga
In the manga, Maxie doesn't stick to one base—he keeps Team Magma moving between caves across Hoenn, running them more like a roving gang than an organized crime outfit. This constant mobility actually worked in his favor, making the team harder to pin down and allowing them to pull off major heists like stealing the Scanner from the Abandoned Ship and both the Red and Blue Orbs (though Amber's Volbeat managed to swipe the Blue Orb for Archie before Maxie could secure it).
Things went seriously wrong after Rayquaza intervened and stopped Groudon and Kyogre from destroying each other. Both Maxie and Archie completely lost it, going on a rampage against anyone who'd interfered with their plans—the Elite Four, Gym Leaders, the Regis, even their own team members. Maxie's Houndoom was responsible for burning Norman during the chaos.
Archie later revealed that Maxie didn't survive. The Red Orb had overloaded his body, and he literally crumbled to dust.
Content compiled by AnimeList.moe from publicly available sources.