You can have whatever goals you like, but that doesn't entitle you to live in an area you can't afford.
This is a failure of city planning and should not be excused or ignored as if this fialure was inevitable.
Careers in the arts are generally regarded as belonging to the second category for all but a handful of lottery winners.