Big cities are "terrible" long-term, especially as viewed by most average people who lack the skills, connections, and abilities to utilize them and as they get older and less able to capitalize on them. Younger, smarter people tend to gravitate towards them as they are able to make more effective use of cities with better goals, tactics, self-discipline, sociopolitical navigation, and relationships.
YMMV.