Damn tough question!
Jazz: I've seen Michael Brecker blow several times, once around the Don't Try This at Home period with his EWI, and another much later... unbelievable. I've had the pleasure to sit in front of Stanley Turentine, Keith Jarret, and McCoy Tyner: all stunning. But... Herbie Hancock and Wayne Shorter was transcendent.
Orchestral: I was blessed to grow up in St Louis with Leonard Slatkin conducting the orchestra and have seen some magnificent performances... but MTT conducting the SF Symphony Orchestra performing the Rite of Spring
Comedy: No Brainer... George Carlin at Davies Symphony Hall...
Hip Hop: KRS-ONE at the Red Devil Lounge in SF
Rock... Chuck Berry? ZZ-Top? Hell, Billy Joel back in the 80's?
Let's do this:
Best memory: Tom Petty at Shoreline Amphitheater with Los Lobos opening... Encore, Last Dance, and the whole Lawn erupts in lighter flames as EVERYONE lit-up.
Most Fun: Poi Dog Pondering, Blue Note in Columbia MO btw 1992-1998
Best intimate Full-Band experience: Los Lobos at the Filmore in SF
Favorite Rock Concert (all without the band) is a 3-way tie, all sharing one thing in common... The Artist, Solo with their Instrument.
Nick Cave at the Palace Of Fine Arts in SF just a day or two prior to seeing him with the Bad Seeds at the Warfield.
Ben Folds at the Filmore.
Matt Johnson (The The) at the Filmore