2022 and 2026 SF are radically different. Just read all the raves about the current mayor. Maybe about 5% of SF has crime issues. Unfortunately that 5% is near all the convention centers and big hotels so travelers impressions tend towards the negative.

I used to spend some time on Market St in the late 90s and it's not that different than it is now. I'm pretty sure they allowed cars back then. Union Square is radically changed but Market was always a street that lacked what the GenZers refer to as aura. You have all these 5 or more story buildings that feel pretty empty. Wide sidewalks with people speed walking to work. OP would like it to be more like the Mission. But those streets have the requisite low rent needed for small artisan stores to flourish.