Snug Harbor should get its own category of bar. If I had to choose I guess it has to go into the Dive category. All you really need to know is that it's incredible--a hole in the wall with people from every corner of Charlotte. I won't be a broken record, you can read everyone else's reviews... but just know that if you are looking for a low key kind of night, some good music & heavy pours, this is the place to go.
Last time we were there to see a friend's band play we talked to the bartender who had gotten back from Thailand at 3pm (it was 9pm!). Drinks were cheap and the service was quick. The inside of the bar is really the place to see - crazy artwork, personal touches, random crap - all wonderful. Outside there are park benches and tiki torches where you can hangout, smoke, & probably make some new friends.
If you are looking for the opposite of uptown bars, this is probably a good spot for you!