Price is relative to the occasion. Broadly speaking.
We have a number of places we visit with some regularity - maybe two or three times a year. They vary in price from a local bistro, which charges £19 for three courses, to a more upscale place where we had dinner a couple of weeks back where the bill topped £300 for the two of us.
The upscale places on the list may come into play for special occasions, as well as “routine” visits as mentioned. Outside of those, special occasion restaurants involve travel, so hotels costs become involved, as does transport, if we’re not driving (say if its a London place). Even though price is relative to the occasion, and I wouldnt exclude anywhere I really wanted to go, just on price, I suppose there is something of a cut off. I’ve said I’d baulk at the Fat Duck’s £265 but I wouldnt at their Michelin 3* neighbour, The Waterside, at just under £170. I’d be back to the latter in aheartbeat for a special meal.
Relating to your thread title, we’ve never really considered Noma. I can fly there in less than 2 hours - quicker than I can drive to the Waterside and about the same as the train time to London. But it was too expensive, too much of a faff to make reservations. And, truth be told, I’m not sure I would enjoy the food as much as I think I should at that cost. There’s something about wanting simpler food, done really well. Give me three superb courses, maybe throw in a couple of snacks to start, a pre-dessert and some petit fours with the coffee, and I’m going to be a happier camper than eating a 20 course tasting menu.