MW’19 had the least amount of goofiness. & Hey, nobody knows for sure what’s gonna happen with BF6, either in next 6+ months (hope it stays grounded). But 2042 had some goofy stuffs as well.
If BF6 sticks with the theme and the public supports it, maybe IW will follow suit as well for the next MW. (well IW delivers the package as realistic as possible, its the other CoD team(s) in charge of the post-launch skin design & support). But remember, its the fanbase that buys the rainbow skins and encourages the publishers to add more of ’em.