From my own personal experience.... with 486 era hardware of course (since that's about where my interest stops).
ISA - WDC Chipset Cards - Used to have a 512K SVGA ISA WDC card, and thing ran great up through Windows 98 SE with the drivers for it. I forget the exact number as it was over 10 years ago, but it was a great 256 color card and not at all slow.
VLB - Chipsets by Cirrus Logic and S3 are the ones I've had the best luck with myself. I use a S3 805 in my current 486 with 2MB of VRAM, it's the ONLY VLB Card I ever got to work with CD-ROAST (which runs in some interlaced 1024x768 graphics mode and looks FANTASTIC on my 14" Micron CRT). It may not be the fastest card but it definatley can hold it's own. I've had TONS of Cirrus Logic cards both in the form of a VLB card and on the motherboard of 486 "pizza box" machines over the years and they never fail to work no matter what O/S I'm using.
PCI - ATI RAGE II - I think I MAY have a driver CD somewhere with drivers for the ATI Rage series, but I've used a ton of those RAGE PCI cards from 2MB to 8MB in Pentium systems, and I had an AMD 5x86 133 with a 2MB model in it, that thing was super happy running Windows 2000 Pro SP2.
Granted, this is ALL historical stuff, I don't have anywhere near the hardware I used to have, though I MIGHT have stashed some stuff away at my childhood home that might get "rediscovered" someday - the majority of it 386-486-Pentium era.
My DOS Boxen
85' Tandy 1000(a)- 8088/4.77, 640K, 8gb XT-IDE, TGA, 3-voice
89' GEM 286 - 286/12 w/287, 6MB, 1GB SCSI, 2XCD-ROM, ET-4000 1MB, SB Pro2
Creeping Net 486 - 486DX4100 WB, 128MB, 512K L2, 15GB+40GB, S3 809 2MB VLB SVGA, SBAWE64