Two members of Red Hot Chili Peppers (Navarro, Flea) played instruments on Alanis Morissette's You Oughtta Know. They were playing the instruments they were known for, however.

Flea also appeared on The Mars Volta song The Widow, this time playing the trumpet. That one definitely fits your post.

I will post more as I think of them.