I think it is fair to say that large cities are more likely to cater to those who are unique, but large cities return to the same problem again: Everything is far away and you have to get into vehicle (granted, it might be a publicly operated one) to reasonably be able to engage with it. The chances of your neighbour being of the same unique blend that you seek is no greater in the city than in the country.
At which point it really makes no difference if you physically reside within city limits or live in a suburban/rural area as the time and effort to get to the places that cater to your particular niche approaches being about the same in all cases. In fact, in my experience, it is often easier to access the amenities of a large city when you don't live in it!