I really enjoyed the John Fogerty concert last weekend, its right up there for me. The Hip always put on a good show and U2 in 1997 was pretty good too.
For a smaller venue, The Hugh Dillon Redemption Choir (former lead singer of The Headstones) two years ago in Edmonton. Not a really well known guy but he has an incredible stage presence and has to be the coolest MOFO to ever walk the face of the earth. You have to love a lead singer who will actually reach into the crowd and smack people upside the head when they start acting like idiots.