My only experience with Amsterdam is Schipol airport. Really i just looked at a lot of reddit Amsterdam and tourism forums and I dont think I was too far off. Maybe no SF but similar attitude and vibes, I wasn't going there for the "coffee shops" or red light district. Their online persona matched NYC smart ass or California snob to me.
My German cousin told me similar things, they like to go to some island off Spain (not Ibiza, Mallorca) and Italy. Amsterdam was either a tourist trap or hipster haven.
Gotcha! That "snobby" feeling makes sense to me. I'd visit other places in NLD before Amsterdam again. The Amn Frank House, Bols distillery, and some of the museums are worth it, but only enough for a day trip. The Hauge is a better spot to be at.