I actually really like the SNES game, it is objectively not great though. You can't even save, so emulation is a must unless you can dedicate an 8-10 hour sitting to it.
Particularly that it switches between top-down outdoors and a pseudo-FPS indoors, and the claustrophobic interiors and darker music give it a lot of charm.
Trespasser was a vibe in some ways. The clean screen and unique control scheme was innovative at the time. Granted it doesn't hold up very well now, but there were some cool concepts at least.
I have fond memories of a game called dino defender. I played it when I was like 5 years old so the game might be bad but maybe not!
Another game from that era that seemed cool but I could never get to work on my computer was scan command. It came with this barcode scanner you could use to scan various barcodes, which would give you pieces to build your own dinosaur fighter thing. Seemed cool, and I scanned the heck out of barcodes ... But never got to see the fruits of my labor 😔