Unfortunately, I don't know of a general list of cards that work with the VFX-1, only forum scuttlebutt that says certain ones do and certain ones don't. AFAIK it's not even guaranteed to be consistant across cards from different manufacturers with the same GPU.
I didn't realize RealMYST was a 2000 game - I thought it was newer, like 2003-4. That opens up some more options, at least there's a bit of overlap there. Maybe an S3 Savage4? Last I remember, SiliconClassics was using an S3 card with his VFX-1 - they usually require a small (few bytes of assembly) utility to enable the VFC, but no big deal. Again, NO idea if that extends up to the Savage4 or later cards but at least they still have the header.
I think the most powerful thing in my stash with a VFC is a Quadro 2 (~GF2 Ultra), but I've read in a couple places most Nvidia cards don't work. I also have a couple GF2 MXes & TNT2s with VFCs, and a Radeon 7000 DDR with empty solder pads but I haven't tried soldering that on.
I went the Rage (II+) route myself, although I have an LT Pro that would probably work with it. TBH I've been reluctant to experiment because SiliconClassics reported it's possible to blow the decoder chips on the VIP card if you plug the VFC cable in backwards - and of course it's not keyed. Be careful when swapping around.
Edit: I wonder if you could get a playable experience in RealMYST on a Voodoo2?
twitch.tv/oldskooljay - playing the obscure, forgotten & weird - most Tuesdays & Thursdays @ 6:30 PM PDT. Bonus streams elsewhen!