Thankfully, we still have our minor league ballpark... it is being used by our Coastal Plain League team, the Columbia Blowfish (yes, the name descended from the band) in the summer and all the seats are cheap... $7 reserved field level, $5 gen. adm., and $4 seniors and kids 12 and under.
http://www.blowfishbaseball.com/
http://www.coastalplain.com/about/today
Excellent local bands playing in a restaurant/lounge is usually only a $5 cover, and if it's a lesser-known national or regional touring band (I'm referring mostly to blues, jazz, or folkie stuff) it might be $10.
More well-known national/regional alternative, punk, hardcore, and similar bands are through here all the time and play in larger "concert venues" (basically clubs that might hold 100-300) and get $15-25 (and sometimes higher) covers. Once in awhile somebody like Charlie Hunter will hit one of these clubs, but the tix are still reasonable... $10, 15 or 25.
We've got a beautiful old 3200-seat concert hall where "larger" acts perform. Still has reasonable prices, IMO. Ryan Adams and the Cardinals will be there in early March and tix are $23-33. Bonnie Raitt will be there on the 21st and tix for her are $45, 55, and 65. Fairly reasonable, but this is a No Nukes benefit. No thanks if you know what I mean.
Then there's the Colonial Center where USC plays its basketball games and where the Monster Truck Jam, The Wiggles, Sesame Street on Ice, Ringling Bros. Circus, and bands like Springsteen, Chesney, Keith, Elton John/Billy Joel, Bette Midler, etc. perform. Their prices are typically as high as anywhere else that hosts bands like that, and I've never been there to see anything since they opened it around 2000 or '01.
Before that, USC played their games in the Frank McGuire Arena, and I've seen loads of concerts there... from bands like Steppenwolf, Guess Who, Delaney, Bonnie, & Friends, Allman Brothers, Butterfield Blues Band, etc. in the days when tix were $5-7 all the way to Springsteen, Willie Nelson, etc. when the tix were $25-30.