Yes, excellent, especially Amos and the Quivering Brethren.
More fictional taverns I’d like to frequent: Lux from Lucifer and Quark’s Bar, Grill, Gaming House and Holosuite Arcade from Deep Space Nine.
Ooooo… I like it: a virtual, fictional pub crawl… ignoring time, space, distance, and well: reality. 
Any General Systems Vehicle from the Culture. (OK, maybe not Meatfucker. And it was a smaller GCU anyway.)
The whole point of the Culture is that it is human imagination unbounded. You could be, do, experience anything you could imagine. Any gender, body type, entity. Go anywhere.
“It’s more fun in The Culture!”
Japanese anime is often based on real-life locations. There’s a not-trivial tourist industry devoted to anime settings.
News article: about 5% of tourists in Japan surveyed said they had visited an anime or movie location. https://www.japantimes.co.jp/news/2019/09/15/national/japans-anime-tourism-lucrative-blend-cash-chaos/
Scientific article on the subject (!): Anime pilgrimage in Japan: Focusing Social Influences as determinants - ScienceDirect
One of many webpages showing real life pictures alongside matching anime pics. A Pilgrimage to Your Name Locations (That You Can Follow)
Wilhelm Donko is an avid anime tourist who posts side-by-side shots on twitter. https://twitter.com/Surwill
A good roundup of his work: https://www.crunchyroll.com/anime-feature/2018/06/12-1/the-best-of-two-years-of-anime-vs-real-life?utm_source=community_cr&utm_medium=twitter&utm_campaign=news_feature_tweet_from_author&referrer=community_cr_twitter_news_feature_tweet_from_author
I assure you, you do not want to live in Green Acres.
Maybe Sam Drucker’s General Store would be cool.
As a diabetic of course Willie Wonka’s Chocolate Factory would hit the spot.
Yep, I’m just ‘dying’ to go there.
No love for Magentalane? Learn about it here:
Hey, anywhere where the sea of pink champagne flows, under rose coloured bainrows–I mean rainbows–that works for me.
It feels so good to be back at home.
I like the SFPD headquarters in The Streets of San Francisco where Stone and Keller held court (also, Stone’s office in that same building).
If you’re able and willing to travel to Ticonderoga, NY, you can visit the TOS Enterprise. This guy has built an exact replica of the set.
Come to think of it, I wouldn’t mind at least visiting or maybe even living in a lot of the villages shown in Midsomer county. As long as I don’t become one of the victims.
Nobody wants to go to Manderley? It sounded like a lovely estate except for the creepy housekeeper. I always wanted to sit by the fire with my spaniel Jasper at my feet.
For that matter, Downton Abbey looked like a very nice place to live, as long as I could be an upstairs houseguest. (Although the formal dress code would be a bit much to deal with.)
Portmeiron is well worth visiting you happen to be in the area. It still looks exactly like it did in the show, beautiful and slightly odd. People actually live there!
I like most of the art deco locations in Agatha Christie’s Poirot novels. My favourite is probably Eltham Palace, which was used in Three Act Tragedy and Death on the Nile. It’s not actually a palace, merely a large art deco house, but it’s gorgeous, with lots of fitted furniture, curved white lines, sunlights and so on.
The Restaurant at the End of the Universe would be fun.
For a place I could actually visit, wherever Doc Martin is filmed. If the Large’s restaurant is really a restaurant, I’d love to have dinner and drinks on that patio.
That’s Cornwall, and it’s a great destination even without the Doc Martin stuff. There are lots of shops and tours and stuff related to it down there - I don’t know if the restaurant is real, but I know you can stay in the cottage that’s used as the exteriors for his home.
Nathan’s home in Ex Machina is actually a hotel in Norway where you can stay for as little as $200 a night (once you’ve made the considerable effort to get there).
Not sure if it’s “beloved,” but it sure looks pretty cool.
No dispute. But the scene is most congenial as long as neither Barney nor Gomer show up. (ETA: nor Dennis the Menace.)
This leads me to think of the San Francisco Bay Area and some of the surrounding environs (Marin, Sonoma, Napa) as they were 50-some-or-more years ago, as remembered by me, seen through fantasy rose-colored glasses. (Hey, you said anything fictional, right?)
Today, way too over-built, congested, polluted, gentrified some places, run-down and shabby in other places.
I’m more an armchair explorer now, especially in these covid times. A long time ago I discovered an acquaintance going to that area, and convinced him to go. He pretty much agrees with you.
Just don’t go to Portmeiron during a Prisoner festival. I think they’re biennial events, with lots of “activities” (including a tournament using the human chessboard, of course). But I’d hate that, preferring a little quiet.
ps, I love this concept. Who cares if I can’t travel; I’ll pick a spot and research it, and immerse myself in photos and articles and movies until I feel like I’ve been there.