My last trip to Paris was 1 year ago and it was pretty bad compared to NYC, Los Angeles, and San Francisco for the average tourist - especially at night.
You don't see people shooting heroin literally 5 metres away from a tourist attraction in Paris (for the record - right next to the queue of tourists to get on the cable car at Powell/Market stop).