I have lived in NYC, SF, Austin, Brussels, London, and now Columbus OH, with my music. I would say that each of these cities had a great scene when I there. I left them because the scene died. Columbus I can't comment on because I haven't ventured in there enough yet. Austin is a mere shell of what it was. If you are coming from a place that is musically dry, you will be impressed, but when I was there 80's-90's, it was cooking. There were over 150 bars to play, and a house could be rented for $200 month. In the 90's it started to boom business and real estate wise. That same house was then close to a grand a month......... Most all but the longetime and famous musicians had to leave. That killed the root of what made it famous. NYC had a great scene in the 70's, but it too has died. SF was cooking in the late 70's when I got there and it too has cooled way off. My youngest brother lived/played in Seattle during the grunge days. He has since moved to LA and says it is pretty dry as well now.
I guess what I am saying is the scenes that were, and are no more. They most likely will never see the grass root movement that made them so famous today. That is a sad result of vibrant scene that gets worldwide recognition. Nashville is another example of this phenomenon. These places are great for tourists to visit, but are not going to support the local (not national stars) music scene anymore.
I am not sure where the scene is happening now. I basically just play for me, so if I am in the mood, the scene is hot
I feel for the young musicians. The cost of fuel, hotels, and the pay having decreased at least 50% from the 70-80's, makes for a tough road. Follow your heart. If you are passionate, you will be a part of creating the new scene! Walter