This card has that SVGA scrolling compatibility bug (no memory wraparound in VGA after 256KB mark) , so Commander Keen needs SVGA Compatibility enabled, or half of the screen goes missing:
The attachment KEEN5-needs-svga-compat.png is no longer available
Maybe the biggest downside for many old DOS games is that the adapter is quite slow to run many games, e.g. Wiering's Mario and Jazz Jackrabbit are unplayable, and it is too slow for many demo timings, here Kukoo 2 demo glitches pretty badly:
The attachment KUKOO2-tooslow.png is no longer available
However, the card does still carry the EGA sized fonts so Sim City works and is playable without a TSR fix:
The attachment SIMCITY.png is no longer available
In Windows 3.1, the built-in 800x600 SVGA driver should work since SVGA modes 5Bh and 6Ah are 800x600 56Hz 16c. Using Trident 8800CS drivers, I was able to get that 1024x768 86Hz interlaced 16 colors mode to work:
The attachment WIN3.1-1024x768i-16c.png is no longer available
Overall, a VESA driver might be able to be set up to advertise the video mode initialization some of these custom 640x400, 640x480, 800x600, 1024x768 16 and 256 colors video mode capabilities, but I don't know either if anyone might have developed such a driver. If there is a VESA driver for Trident 8800CS somewhere, that should work.
In the Trident_TVGA_8800_and_8900.rar package (from Vogonsdrivers iirc) I could find only a bunch of manual application-specific drivers, i.e.
The attachment Trident_TVGA_8800_and_8900.png is no longer available
but no VESA driver.