Ultimate Super Doom 3 is one of the best total conversion gameplay mods ever made for classic doom. It faithfully recreates the mechanics, enemies, guns and feel of Doom 3 perfectly. Now a lot of people don't like doom 3 much, but I don't mind it, especially considering all newer doom games have stupid jumping crap thrown in.
I found this mod a long time ago searching for a doom 3 gameplay mod for zdoom. I was working on something similar but far worse. This mod is amazing. It imports all of the enemies from doom 3 into doom/doom 2 and does the same thing with guns. Even better, it takes the stuff from the doom 3 expansion, resurrection of evil and imports them too. Being a huge fan of ROE I loved this. I got to fight bruisers and vulgars again. And the quality of the work is quite insane considering all the sprite ripping he had to do to get the mod working right, as the mod uses sprite rips, not models to draw the new graphics.
It's one of the best mods but to really enjoy it you will need some other mods. I recommend Ultimate Doom visor for it's outdoor damage effects and darker lighting settings. I also recommend this texture replacer I found on youtube that replaces all doom 1 and 2 textures with doom 3 ones. I also recommend some kind of ambient music pack as well. To find this mod search for it on google and click the link to moddb and download the file in files named volume 4.5
Overall this is fun as all hell.
Screenshots:
(This screenshots was taken using an obaddon map and retexturing it with the above texture replacer, the mod itself doesn't have new textures)