Depends the game, of course, and the intent of the visual direction and the audience. But if your game is supposed to uphold an even marginally coherent visual identity, and you're pissing it away with dumbshit goof costumes from the onset, you can be sure I'm fucking that shit right off into the bin where it belongs. They're usually fun for replays though, see the weird Sleeping Dogs outfits.
It works in something like Mario Odyssey where the game's visual identity is inherently disjointed, cartoonish, and varied. It doesn't really matter that Mario is wearing absurd outfits, because everyone in the game is to some capacity, and in a single stage you'll find people wearing all kinds of shit. The incoherent mix match is largely part of the identity itself.
But I also find it a bit jarring in general, particularly when it comes at a cost of what I perceive as silhouettes and quick glace visual identifiers. I think there's a point when a game has gone totally overboard with variety of skins and outfits and costumes or whatever and has become an horrible, visually jarring mess of incoherent styles that makes the end result look like a dumpster fire of Skyrim mods. And even then when it is somewhat grounded it hurts the visual readability of the game. Battlefield V's outfits are fine in theory, but the consequence of mixing and matching is that it's now literally impossible to tell what class an enemy is.