As for SF: Most of the OGs left a while ago, it's basically like a post-Palo Alto now, a lot of AI startups, and a mecca for recent grads to keep feeling like they're still in college except substitute AI startup for school. They even look a lot like students, plus the typical SF activities: Biking The Wiggle, people running in the Panhandle, sunny days at Dolores, weekends in Napa.
On the entrepreneurial side, it's like these WeWork single-founder startups from the Great Lakes region (Michigan, Canada, NY) who are doing everything from crypto bro stuff to trying to build tech for acquire-hire, flying through engineers and designers to do so. On the enterprise side it's mostly companies servicing all these: Rippling, WeWork, Vercel, cloud providers, payment providers, Salesforce.
The entire Bay Area is getting calmer and more neighborhood-like: The peninsula and East Bay seem nicer than ever. A lot of SF people moved to Berkeley and Santa Cruz, and towns like Redwood City are really shaping up into lovely suburbs. Where I live (Upper Haight, SF) the old school skateboard/pizza/weed/fashion vibe is coming back, the Dead Heads are not a very strong influence anymore but there are some, kinda feels like a little 90s pocket here, but we lost a lot of live music and a lot of culture. The whole city seems to have lost a lot of music, restaurants, and entertainment - it's overall pretty boring right now. There's more spontaneous live music in Santa Cruz or peninsula. There's a pretty strong homeowner and gardening vibe in a lot of neighborhoods of SF, the Slow Streets thing is making it feel more suburby in areas. Bernal is stuck up beyond belief, just like before but multiply it, it's gotten more sophisticated, same homeowners up there as before, Good Life still there, remodeled but the same basically. Noe is strange, the babies are no longer babies but now giant 10 year olds, feels like an urban kid-ran neighborhood over there - strong cul-de-sac family vibes. More surfing and skimboarding at beaches than I remember from 10+ years ago, more action sports in general - skateparks have improved. Bike lanes and roads have improved, overall crime is lower and things are cleaner all over the Bay Area except for the classic bad spots of East Bay.
I've lived here for most of my life so it's hard to compare it to other places, I would say it's maturing and improving and I expect the West Coast in general to fill out like the East Coast over the next 100 years, so I take that into consideration with the overall growth trend. It's still very much a place of building and construction and growth. Though as I say this I've seen more "For Rent" and "For Sale" signs on buildings than ever before within SF - I think the surrounding areas are growing more than the city, the city is overall somewhat boring and quiet but I love it.