Mr Bungle. The singer from faith no more. Apparently he liked hiding his turds in ventilation ducs in the hotels while he was on tour. Also made fun of the other lead singer of RHCP.
He thought Mike Patton was biting his style! I recently watched the video for Epic and I can kind of see what Kiedis is saying but honestly RHCP never had a hit like Epic before it was released. Mother’s Milk was released a few months later.
Captain Sensible. He was the guitarist for the punk band The Damned, but had a #1 hit in the UK with “Happy Talk”, a song from the 1949 musical South Pacific.
I second most of these other recommendations, but since I haven’t seen them said yet, The Magnetic Fields. Somehow manages to be funny while also being very geniune and touching, which I think is kind of what I look for in a band.
Peter Gabriel era Genesis was pretty goofy, as well as some of his solo stuff.
King Gizzard and the Lizard Wizard is pretty much the goofiest band known to man right now; especially if you listen to their earlier stuff like Cellophane or Vegemite.