The Rose isn't fancy, but it is one of the best dives I've found in Charlotte.
Great beer specials everyday, really good (and reasonably priced) food. Plenty of TVs to watch whatever game you're looking for and a great wait staff that after a few visits will know your name and what you are drinking!
Karaoke on the weekends (and I think Tuesdays?) -- great for the more ambitious, or just those that enjoy fantastic people watching.
PS: As for menu recommendations, try the Manhattan and thank me later!