The Cyriak wads are god tier:
Going Down - https://www.doomworld.com/idgames/levels/doom2/Ports/megawads/gd
Overboard - https://www.doomworld.com/idgames/levels/doom2/Ports/megawads/overboard
One I found recently through the Dean of Doom that I think has some of the best looking maps out there:
Lost Civilization - https://www.doomworld.com/idgames/levels/doom2/Ports/megawads/joi_lstcv15
Also, here is a great one for HALLOWEEN, Unloved! Silent Hill in Doom.
Unloved - https://www.doomworld.com/idgames/levels/doom2/Ports/s-u/unloved
If we are talking gameplay wads, nashmove is one I really enjoy. (Even though it can break some maps. But easier platforming/easier to selectively pick up items makes it worth it!)
Nashmove - https://forum.zdoom.org/viewtopic.php?t=35761&hilit=nashmove
Total Chaos is barely even doom, but I love it so much! A lot of my love for it matches reasons why I love Unloved! Cry of Fear in Doom.
Total Chaos - https://www.moddb.com/mods/total-chaos