Loads of bands have made me go Wow but most recently have been blown away by Midlake and Oceansize.
Over the years, Metallica, Pearl Jam, Ozzy, Fishbone, Kings x (all in small venues have been awesome).
Special mention to Spiritualized, Arcade fire, Nick Cave and Elbow as well.
By the way Tn – Ramonez were pretty average when i saw them.