I was very excited to visit for the first time and it turned out to be incredibly disgusting. Wow, just thinking about the smell when the sun came up.
Other big cities that I was excited for and let down... Philly, Jax, El Paso, and Baltimore.
Big cities that surprised me in a good way: Charlotte and Ft Worth.