Be aware that different voodoo cards and versions of unreal will also bring different visual experiences for Unreal. Just a "Get VooDoo !!" is not the end all silver-bullet for Unreal and will be another rabbit hole of its own.
The Banshee as mentioned, will get you overbrights because GlideDrv can't do the multitexture path (more optimized but clamps lightmaps/blends detail differently) 😀
Older versions of Unreal (prior to 222) aren't compatible with the Voodoo3.
The multitexturing is also another subjective element because Unreal didn't initially release with that capability! One big element that has been divisive are how the lightmaps combine with blended textures such as layers of skies. Both the Kentie and Dohnal drivers handle and treat these differently and some prefer the other. (personally i think unreal's meant to be played with sgldrv)
After multitexturing was added, GlideDrv had several updates in patches that shifted the lightmap data differently to compensate for the alternate, overbright-less combining. The initial addition didn't at all and rendered Unreal *VERY DARK*.
(MMX is NOT required for running Unreal but stresses its importance for sound mixing and will force low quality sound if it can't detect MMX extensions.)