I wanna look more into the modding/custom scene of FPS games from the 90s, it seems woefully undocumented

At least, in regards to some games. The big games like Doom, Quake and Half-Life are about 95% covered outside of a few rare instances.

Other games, not so much.