Cirrus Logic and S3 cards are the go to cards for retro DOS machines, i have a Cirrus GD5446 2mb, S3 Trio64 2mb, a couple S3 Trio64v+ 2mb (1 is a phoenix 64v+ and the other one is a number nine 9fx motion 331), and a S3 Virge/DX 4mb, they were pretty good with DOS games. nVidia cards are also a decent choice too, a TNT2 M64 works okay for DOS games, i don't know how trident and tseng is and i know that ATI and Matrox have issues with scrolling in Commander Keen
Cirrus was a brand I avoided in the 1980s, like ATI, Trident, Paradise and many others. Bad drivers made them a nuisance.
In my experience back then Matrox Mystique was the best on ISA, The drivers for Windows 3.0 and 3.1 were excellent, this made the biggest difference.
For normal good user experience, Tseng ET3000 and then 4000 was the card to go. Unspectacular. But many OEMs delivered bad drivers, you had to stick to known good drivers and use them universally.