Hmmm...from most well known to most obscure, perhaps?
Steven Tyler from Aerosmith (used to frequent my coffee shop)
LL Cool J (he was hitting on service worker at airport)
Donovan (waited on him at restaurant)
Wayne Coyne of Flaming Lips (played boombox for at show, conversed in passing several times)
Jonathon Richman (of Modern Lovers, met at coffeeshop)
Helios Creed of Chrome (played show with him)
William Elliot Whitmore (a friend, stayed at my house, I've stayed at his)
The Gossip (olymia 00s dance/soul band, stayed at my house)
Ten Grand / the Vida Blue (00s screamo, iowa city, friends of friends)
Low (slowcore 90's band from Duluth, met and conversed many times)
Craig Finn (of Hold Steady, used to date my coworker)
Son Volt (ex Uncle Tupelo, worked with)
Old Time Relijun (olympia band, played show with them)
Deerhoof (sf indie noise rockers, friends of friends)
Dark, Dark, Dark (00s mpls/new orleans/new york, used to be close friends with)
Erase Erratta (SF noise rockers, stayed at my house)
Mono (japan instrumental, played show with and stayed at my house)
Burmese (sf noise rockers, layed show with them, friends of friends)
f**k (90s indie pop band, stayed at my house a few times)
No 1 Cup (90s indie rock, chicago, stayed at my house a couple times)
Warhammer 48k (00s grunge noise from Columbia MO, played many shows with, vy influential)
Cave (ex Wh48k)
Neptune (Boston art rock, recorded CD for them, layed shows with, stayed at my house)
Gay Beast (00s noise rock, minneapolis, recorded them, played shows with & printed album covers for)
And many more ... hundreds of bands. The ones I could remember that I put on the list all have made at least 3 national or european tours, which is famous enough for me, I guess.