I can speak to this a little. I'm from a Midwestern city and moved to SF and NYC for long periods.
In NYC, LA, SF, you are surrounded by literal billionaires, you walk past (or into) the HQ of Google or Meta or Twitter everyday. You are surrounded by the financial industry, or Hollywood, or the tech giants. You meet people who raised ten million dollars for a startup and that's just a Tuesday for them.
Being around so much success, so many unicorns, so much wealth, you somehow became a bit more optimistic about things and think those things could become possible for you or people you know.
If you spend your entire life in a place where the pinnacle of the local economy is a random agricultural F500 company or some trucking giant or maybe the local research medical hospital is the state's largest or wealthiest employer, you somehow just become a bit less optimistic about moonshots. The idea of the biggest success someone could realistically expect is creating something as big as Kickstarter, or as big as ButcherBox, or a competitor to Wordpress.
In NYC/LA/SF people are more likely to legitimately believe they might create the next Facebook/Twitter. And if you share with others that level of ambition, they might be doubtful but they won't necessarily see you as a fool. In a lot of smaller cities, you'll straight up be seen as a moronic delusional fool by sheer reflex.