Some good information about "mode X" and other arcana can still be found online. Tools, even, to screw around with it:
http://bbc.nvg.org/private/programming.htmlOld Dr. Dobbs articles contain a lot of information about this sort of thing too. Stuff like that, plus Michael Abrash, is how Quake came with support for so many oddball modes -- you don't normally think of VGA as supporting such things, but VGA itself is just a bunch of registers, the better question is whether the monitor can lock to the scan rate -- or catch fire trying!*
(*AFAIK, this wasn't
actually a problem for IBM PCs, but some really early ones (Commodore something or other maybe?? I don't know) had a "killer POKE" that could do something like abuse the scan rate circuitry, resulting in... dangerously incorrect operation.)
There's also all the VESA (SVGA) extensions, which I think is what Duke3D used at the time for its support of not-quite-as-oddball modes?
Also keep in mind, "CGA", "MDA", "EGA", "VGA", "XGA" etc. were creations of IBM -- they produced cards and chipsets with these designations, and led industry support of them. Most 3rd parties that copied these, added their own extensions. SVGA however is -- I think? -- just whatever they wanted to put into their cards, somewhat more loosely by industry agreement. So, that things were as consistent as they were, was a byproduct of the unique situation IBM held in those early days (mid 80s to early 90s say).
Since then, ever more so, drivers have been necessary to use much of the features available between different cards. I don't know exactly how much hardware compatibility remains today; SVGA I think is fairly universally supported? Conversely, a lot of cards don't even boot in text mode as such, but a graphical emulation of it at a resolution closer to modern displays.
Tim