Phil's computer lab made a very good video about this, can't put the link now.
I would say:
Early socket 7: something very compatible, i would choose a trident 9680 with 2mb, because it has very good performance and it tops out any processor up the p133, i will pair it with a voodoo 1 4 or 6mb.
Late socket 7: taking the pentium mmx 233, i will say a voodoo 2, or something similar, like a TNT or a Savage4, because it'll be a good pair.
Super socket 7: using a k6-2 450 at least, the best will be the voodoo 3 3000, it has the best compatibility and quality, all the others have some drawback, if you want 32bit rendering, you can use a voodoo 4 4500 but it doesn't have better performance.

Some matrox 4mb -> voodoo1 4mb. Also used a riva 128zx. Both AGP.

Early socket 7: something very compatible, i would choose a trident 9680 with 2mb

No reason to choose any Trident card over S3/late Cirrus Logic cards. 9680 is a horrible performer.

Well i will choose that because im familiar with that

The original matrox millennium in my s7. Does well. Doesn't do 3d generally speaking but that's what the cpu is for.

Based on my testing a Voodoo 4 has significant performance increase over a Voodoo 3 3000 in Quake 3.
http://www.vogonswiki.com/index.php/3dfx_Benchmarks

I would agree V4 32bit is similar to V3 16bit in performance.

I only have one active socket 7 rig and it's an MMX 233, which is my main MS-DOS machine but can also boot Windows 98. Before having a chance to grab a Voodoo 3 PCI, my choice was any of the Matrox PCI cards that I have on hand (Millenium, Millenium II and Mystique) plus a Voodoo 2 (I never had any Voodoo 1, which probably would be a better fit). As an alternative, I have all kinds of S3 cards but I never considered using them; they are sooo uninteresting 🤣

Now having a PCI Voodoo3, I just use it and completely happy with it. Please note that I'm not into DOS games released before 1992-93, (oldest in this system is X-Wing for example) and have nothng to do with side scrollers and other arcade/action type games which are the most whiny about compatibility.

I have Mach64 or Rage3D cards in my socket7 machines. I also have one S3 Trio and one Cirrus Logic card but they're both worse performers than the ATI cards and video quality is also worse on them. I would like to experiment with other things but PCI cards don't seem to come by in trash very often and when they do it is another Mach64 or S3 Trio 🤣.

- Matrox Millenium or Tseng ET6000 with Voodoo 1 for Socket 7. I have a Slot 1 with V5, so I don't need too much performance on S7, just compatibility. The choice of 2D card basically boils down to the fact that I like to make my systems more interesting and avoid S3 for that reason;
- AGP Voodoo 3 for SS7 — basically perfect. You don't need 32 bit colour on that system anyways. I've never actually used anything else on SS7, but I hear it's also preferable because SS7 has a somewhat flawed implementation of AGP, and V3 doesn't have issues with it because it doesn't really use all AGP features (unlike, say Riva TNT2 or GeForces);
- PCI Voodoo 3 for Socket 8 — same, but for systems without AGP.

love my g400max in my ss7 build

Went with a GeForce3 Ti 200 due to its performance in Direct3D, DVI outputs and it's passive cooling (100% silent).
That with a Voodoo 4MB for compatibility.

This on a SS7 w/ AMD K6-III+

It's in my sig. Love these combo's, they work well.

I have a Tyan S1590 (MVP3 chipset) with K6-3+. When I get in the mood, I use it for benchmarking various things. It's a very slow project, but at some point I hope to make some comparisons against some other builds (which haven't been built yet).

I haven't tried the Voodoo3 3500 yet. I'm sure it's a good match, but if I build a system for Glide, I think I'm going to be more concerned about maxing the potential of the card rather than maxing the potential of the CPU, so I'll probably prefer the Voodoo3 in a Pentium 3 machine.

I tried the Matrox G400 and it was pretty fast. As I recall it was close to the performance of a Geforce2 MX in some stuff, but I don't have my spreadsheet in front of me. I don't have a G400 Max - I probably should have looked for one of those instead of buying a plain G400.

Most of my testing has been with a Geforce2 MX (AGP). I haven't had any problems with it, but I'm used to this setup, having used such a card on this same motherboard back in the day. I went through some pain back then, but I know how to make it work now.
Performance with different nVidia drivers is erratic on my super 7 machine. One driver will be fast, the next will be mysteriously slow in some games but fast in one of them, the next few drivers will be more consistently fast again, and even later ones will be so slow they seem broken. Testing different drivers is a major time sink, unfortunately.

My motherboard has 2 significant faults IMO. One is it's lack of an AGP1X/2X toggle in the BIOS. I force AGP 1X when installing the VIA AGP driver, but I'd be a lot happier if I could control that in the BIOS. AGP 2X on the MVP3 is broken, and it serves no purpose anyway. Back when I used to try using it, the performance difference was so tiny as to be completely meaningless. This chipset should stay in AGP 1X only.
My other complaint with the Tyan S1590 is that if you want to use the AGP slot then you have to install it in an AT case. If you put the board in an ATX case, the AGP slot is inaccessible. They put one too many PCI/ISA slots underneath it.

I expect to try a Geforce2 Ultra and maybe a Geforce3 in the future, just for the heck of it. Those cards' power consumption scares me a bit, but I think it will be okay as long as I use an ATX PSU and not an AT (my revision of the Tyan S1590 will utilize the +3.3V rail from an ATX PSU, it's wired in parallel with the output of the onboard linear regulator).
The appeal those cards might have on a super-7 is that some versions of them have DVI output, and they can still use fairly old drivers.