I fondly remember this stage back in Melee, but apparently not well enough as I had no idea it wasn't in Brawl or Smash 4. It did finally return in Ultimate. It's based on Peach's castle in Super Mario 64 on the N64.
Not much has changed since Melee besides a little better graphics on the textures. The main thing to look out for is this guy. He packs a punch and you don't want to be in the radius of the impact.
But I like it because it's a medium-sized map that pretty well balanced.