The title of this thread is worded oddly - it seems like what the op was trying to get at is "Assume that your personal Heaven/Afterlife is in one of the Zelda universes, what specific area would you like to live?" rather than what "game" you'd live in.
I think the game-world of Twilight Princess would be suited to me, specifically any area that's under Twilight because I've always loved that time of the day. I can see TP's version of Kakariko Village or the Hidden Kakariko Village as nostalgic for me, considering I grew up in Arizona (and the thread about what real world places various Zelda locales correspond to has a lot of us pinning "Arizona" on the place). I also rather like both for the relative isolation. (Yes, I can see myself living like Impaz, the crazy cat-lady). In fact, one of the original short stories available for reading for FREE on my blog that I did recently features a "deserted city" as someone's mysterious personal Heaven. (Yes, I do think like that. No, I don't do illegal substances and the legal ones are supposed to balance me).
Living alone with a thousand cats in a deserted old westy town in a twilight-afflicted land actually sounds pretty "Heaven" to me.
I almost picked Skyloft, but then I thought about all those skydiving freefalls I'd be expected to do. I actually enjoy heights and lofty views, but I have a serious viceral phobia in regards to falling/falling sensation. Skydiving wouldn't be on my bucket-list because it would cause me to kick it via panic-reaction heart-attack, so I'm content to do it only as Link, on a nice, safe screen.