I’m a big fan of the (now defunct) Japanese band Kagrra,. One of their guitarists also played a Japanese string instrument called a Koto (as in this song Uzu).
I remember Brian Jones of The Rolling Stones played the marimba in “Under My Thumb”, and John Entwhistle of The Who played the french horn.
Are there any other bands where one of the regular musicians plays a non-traditional instrument, both in the studio and live?
The E Street Band had saxophonist Clarence Clemens as part of their line-up. A lot of rock bands have brought in an occasional saxophonist but few have one as a regular member.
David Bowie’s “Space Oddity” features a stylophone.
The mid-'70s band Sailor regularly used a keyboard instrument of their own invention, that they called the nickelodeon. Curved Air featured Darryl Way’s electric violin.
And, of course, the Velvet Underground had John Cale on viola.
Cleis Pierce played an electric viola in the art-rock band McKenzie Theory.
Almost every member of Gentle Giant played instruments unusual for rock music, including recorder, “Shulberry” (3-string custom electric ukulele), vibraphone, xylophone, mandolin, clarinet.
Frank Zappa and his bands of course have played almost anything, including a bicycle.
Juicy Lucy featured a steel guitar played by Glenn Campbell (no, not that Glenn Campbell) very much in a rock style, very different from the way it is more traditionally used in country music.
The Doors, most unusually for a rock band, did not have a regular bass guitarist. Although they used a session bassist in the studio sometimes, when live (and I think on some studio tracks too), organist Ray Manzarek would play the bass line on a Fender Rhodes piano bass (whilst playing the other keyboard parts with his right hand).
The Bonzo Dog Band had members playing the euphonium, trumpet, tuba, harpsichord, banjo, spoons, accordion, tap dancing, slide whistle, and a trouser press.
The Lovin’ Spoonful often had John Sebastian on autoharp, at least on some of their TV performances.
Otis Taylor plays blues, but often includes a cello and a banjo in his songs.
The Who also wanted a cello for “A Quick One While He’s Away,” but since none of the band played one, they sang, “cello, cello, cello, cello, cello.”
And while Springsteen was one of the last groups to have a saxophonist, they were very common in early rock: the Dave Clark Five, for instance, had one.
If you’re thinking of “Good Vibrations,” technically it was a “Tannerin” or “Electro-Theramin.” Here’s what it looks like. It’s different enough (IMHO) to point out the distinction.