Steamed-pepsi did some great
trashed recolors of Maxis doors, including a broken one.
Edited to add: in the style of the Crisps and Kerosene set above, mustluvcatz'
Condemned set.
Not actually broken, but one of my favorites for giving a distinctive, aged appearance, including dirty/clouded recolors for the glass in both windows and doors: Adele's
Liam Build set. Not as versatile because of their distinctiveness though.
If you want to do anything with the walls (like, wall areas under or above the windows---maybe someone tried to break out a window and missed the first time?), Pixelhate made
overlays for those that are not just atmospheric but extremely customizable (and layerable), so you can be subtle (or not) about signs of decay and neglect.
Finally,
this thread has a bunch of other suggestions that might help in setting the mood.