In summary The French Quarter is the best area to stay in Charleston, SC for first-time visitors who want to be steps from Rainbow Row, the most picturesque streets, and the top sights. Marion Square is ideal for those focusing on shopping and dining at the top restaurants.