I also live in a city, Duesseldorf, that's a semi-hotspot. Very crowded during trade fairs, Christmas markets and events like the Euro Cup; not so much in between. Visitors are definitely the reason why there are a thousand bars and stores still open. City centers of comparable cities nearby are dieing. The difference between a thriving city and a mostly dead city are 5.4 million overnight stays.

(Admittedly, Barcelona seems to have about 20 million overnight stays plus cruise ships, but it also has almost three times the population of Duesseldorf)