Early-mid 90s.
The latter years of the NES, the entirety of the 16-bit console era (SNES/Megadrive ["Genesis"]), the golden age of PC adventure games & the dawn of multimedia (CD-ROM based games & talkies).
Just before the release of Doom, where FPS took over; and the PSX/N64, where (bad) 3D was teh hotness; is where it's at for me – likely why I love my MiSTer FPGA so much.
I've only ever really liked the original 2 isometric ones, and Vegas. The Bethesda ones are boring.