I would first like to respond to Snakum's post.
Having lived in NC all my life and having visited the Northeast and Midwest many times, I can agree that Charlotte "ain't" no Boston or Chicago.
I find Typhoonpilot's post very relevant; especially to someone considering moving to Charlotte from a large city such as Chicago, DC, New York City, or Boston. I'm sure it is difficult for northerners to find their "niche" when moving south and vice versa for southerners moving north.
Though Charlotte is a very modern city, it is still a 9 to 5 city compared to our larger friends to the north. Charlotteans, especially native Charlotteans, need to realize that Charlotte isn't such a large city once you cross the Carolina borders. Charlotte simply doesn't offer the entertainment that can be found in larger urban areas. That isn't, however, a negative reflection on Charlotte.
Charlotte is a great place to live and that can be evidenced by its population growth, which includes a lot of Northerners moving there. As a North Carolinian, I really hate the mentality that Northerners aren't welcome (I-77 goes both ways). The more that move here, the better the chance Charlotte has of becoming a city that can be compared to Chicago, DC, Boston, etc. And they also bring a lot of money that is fed into the local economy.
I will, however, respond to the original the original question in the chance others are considering moving to Charlotte. Charlotte can be a fun place to live. There are many outdoor activites available, especially when you condider that you are about equidistant from the mountains and the coast. Charlotte's location provides for numerous one-day road trips and long weekend getaways. Charlotte is home to an NFL franchise and the NBA is returning. Though I stated Charlotte is a 9 to 5 city, it is starting to lose that reputation. Uptown (I guess downtown portrays a negative connotation for an "up and coming" city such as Charlotte) is becoming more lively and it offers theater, arts and museums. Dowtown, excuse me Uptown, will also continue to improve as more and more residential buildings are constructed there. Remember, however, though Charlotte is the second largest banking city in the nation, it isn't Chicago or Boston (just like Typhoonpilot said). Unlike those cities where the fun finds you, you have to find the fun in Charlotte.