Another airline guy checking in here and honestly the only thing that makes an overnight suck is if it’s too short. I hate getting into a cool vibrant city getting put up in the airport hotel. Time for my 6900th shitty hotel burger and fries.. After staying in pretty much every major city in the country multiple times I can confidently say they’re all great. They all also have their rough parts. Use common sense and avoid the rough parts. If you can’t find a way to have a good time on an overnight in LA or SF with some of the best food and bar scenes in the country idk if you can be helped. It’s not that scary guys avoid skid row and the tenderloin and enjoy the rest of these massive awesome diverse cities. On the subject of bodily functions I’ve seen more bachelorette puke on the sidewalks of broadway, 6th, and bourbon than I have human shits in all liberal cities combined. By a factor of ten. Go have a good time and stop letting Fox News convince you these places are scary