No, but a number of games have achieved it in certain elements.
HZD - open, hunting, robot fauna, looks like a painting.
GTAV - even now still the best realised world environment in terms of making you feel like being a tourist is a viable gaming approach.
NMS & Elite: Dangerous. While NMS didn't deliver as I hoped, it did recapture a lot of the same feels I had with the original Elite, so I'm looking forward to E
coming to PS4, and maybe PSVR...probably not, but you know...
ND, QD, DONTNOD and Supermassive for both their sense of cinema and literature, and also the exploration of the branching narrative. This is a divergent group for sure, but one I place together because in their own way each one is trying to marry up elements of other media and to tell great stories.
Rez & Tethered on PSVR - Rez because I'm in Tron. I'M IN TRON. IN IT. Tethered because I loved God sims back on the Amiga, and it demonstrated VR's suitability for the genre. Being in the world, picking up real animated critters and putting them down, being there with them for the joy & sadness...I'm really looking forward to whatever develops from the 3rd person platformer demo too...I'm imagining Horizon's world in VR...yeah, I could go for that...
So yeah, lots of games that have childhood dream stuff in them, but then I didn't have a 'dream game' as such...well, maybe an MMO war sim with accurate geography, physics and 000000s of players...or Eve without the admin and slowdown