I don't really see what people would consider weird about LA. The game taking place in a dream, but otherwise being a standard Zelda experience, both visually and otherwise, has never struck me as particularly weird. There's a few threads for fans to pick at, but otherwise it's pretty normal. Super Mario Bros 2 takes the "dream" game direction much further tbh.
Conversely everything about MM is very strange, uncomfortable, creepy, etc. and is very in your face about it both in it's visuals and design. It's a game that likely reflects the mood of a team being crunched to death to get a sequel out as quickly as possible. It being what is, as a big budget release, is already rare enough, but the fact that it's also a direct sequel and entry in a long running franchise, makes it pretty much one of a kind.