i spent 5 years of my life in são paulo, and my feelings are of love and hate regarding sampa. If you are planning to enjoy nightlife and bars, i would suggest to stay in Vila Madalena. Around avenida Paulista, Itaim or vila Olimpia are also good options.
An other good "feira" is Praça benedito...