I am French. When working for a large US company, I visited SF several times between 1998 and 2008. It was usually great, especially in the earlier years.
Then I went to visit with my kids in 2019. Oh man, what a change. The city felt really, really different. Even the guy who was giving us a tour had some nostalgia in his voice.
I won't be back soon.