Amsterdam seems to have gotten better thanks to the pandemic. I go there on a regular basis to visit relatives with kids so I mostly visit parks and playgrounds and the drastic reduction of "bachelor party" type of tourists (coming for alcohol, drugs and prostitutes) has made the city a lot more pleasant to wander around.

Residents seem to have come to the same realization as it looks like they are going to outlaw selling drugs to tourists and move the red light district out of the city.

That being said, as long as there is still the museum/culture tourism and the many wealthy expatriates coming for the quality of life, I do not see the prices dropping back enough to make a difference for regular/local people.