I dont think spray and pray is good, many people around could get shot. I tried the spray and pray thing at the gun range once, its all over the target and around. It's not good unless you are away from people and someone is attacking you.
SHTF vs TEOTWAWKI you ask? SHTF, just some crap on the ceiling and walls, TEOTWAWKI end of the world as we know it. Orignally made by 9mm/®™©