Would you be talking about the season 7 episode titled Masks, Bingo?

I am pretty sure The Inner Light is my all time favorite TNG episode. I find the whole concept really interesting.

I totally ripped it off in a short story I wrote many years back, where a man gets in a fight with his wife, goes out for a walk to cool off, stumbles into a large hole at a nearby construction site, wakes up, and the next thing he knows he is being chased down by an army of ogres, scooped up, thrown into a cage with a bunch of other humans, and sold off as a slave. For the first few years in this fantasy-esque world he is bent on getting home, but eventually becomes invested in his new life, writes off his old life as some weird vivid dream or fantasy, joins in a slave uprising, raises a family, lives to a ripe old age, and one morning wakes up in a deep hole at a construction site, just as discombobulated as the first time around, suddenly finding himself back in a strange existence he hardly even remembers and desperately wishing he could get back.