"left because San Fran is a literal shithole"
What motivates a person to choose a location? Often it is 'lifestyle', which can be interpreted in various ways; partytown, beach bunnies, wealth opportunities, etc. Some of these are of temporary interest and pass as our interests evolve.
When I went to San Francisco it was populated with beatniks; yes, Ginsberg and the like. I got to know them in the dingy coffee houses and clubs of the day. I spent time at Cochran's Billiards where the world's best players duked it out every nite. A few years later SF became a haven for a new generation of artists, hippies, and the Berkeley, Oakland, East Bay revolution. Since the time of Mark Twain, SF has been a hotbed of culture.
I've lived in many cities and long ago found the key to a 'place of interest'. To be interesting, a city must have culture in its slums. My motivation was and is culture and I often find the ghetto is an inspiration.
Tips: you won't find it in Seattle, Denver, Dallas, Omaha, Sedona or Boise. Yes they all have music & art venues for the wealthy, but culture will be harder to find. You might still find it in NYC, SF, Boston, Detroit, Chicago, N'Orleans. Even smaller cities (like the former Sedona or Nashville) can sprout culture. Chicago's underclass was once celebrated by a journalist named Studs Terkel who spent much of his life in barrooms interviewing and immortalizing the LCD (lowest common denominator) people of the city. You could do worse. Culture can happen anywhere but some environments encourage them. When the poorest have culture, you can bet that it is widespread in the area.
-- Or you could choose a location with great beaches, parties, or wealth opportunities.