I think video describes the mod best in under than 2 minutes:
(Removed the youtube trailer, too, because it contained a download link to the mod.)
Features:
- 8 maps in realistic places, but still in Doom style, including White House
- 1 new custom made monster with completely new graphics
- intriguing storyline
- lots of action
- some new graphics
- some new sounds and speeches
- lots of fun and challenge

Download it:
I'm sorry, this entire mod pushes so many rules and bounds of good taste that it cannot exist on these forums. User has been warned. -weasel
Thanks for everyone who made the editing tools, tutorials and these forums!
Oh, and Stormer Doom comes with Brutal Doom.