2nd row is probably the best you can get for just about any concert. Row 1 is reserved for VIPs for most concerts.

I really prefer seeing my favorite artists in small club situations. I've seen Steve Morse both in a stadium (opening for Rush as a matter of fact), and in a small club. The club is much better. I know I'll probably never see Rush or Peter Gabriel that way, but I like the occasional "intimate" show you can get by being a fan of a lesser-known artist.