I don’t know if I would go that far. There is value in getting a BA - it is a requirement for many jobs - regardless of the major. You will meet people who are ambitious, and they will be your friends. There is potential value in the college experience in terms of maturing, in terms of some of the extra curricular stuff one does. My D2 was in a sorority and she received terrific leadership training and she even let some of her academics suffer because of sorority obligations. She got into a grad program that she wanted to anyway.
What I meant was that if you are not feeling the academics, the choice of major really shouldn’t be a huge factor in where you go.
I was in no way implying that you won’t succeed. It just didn’t seem like what you majored in was going to have a huge impact on your life, so walking away from free tuition and spending a lot of your parents money to go somewhere more expensive doesn’t seem like a great investment.
Getting the urban experience can happen on your own nickel just by getting a job in a city.