Um no, at close range (like in a house) you don't get much spread on your shot, you still have to aim, A 2" shot spread at 15' can easily miss.
Lamont
Actually it is closer to point and shoot, like Drac said. Much like pointing your finger. Anyone can point their finger with relative accuracy. If it were a pistol I would agree with you, but the longer barrel means that it is FAR easier to see if you are not pointing at the target. Short barrels take very little effort to pull them off target hence more shooting skill required. It really is all about angles (a little bit of geometry).
A shotgun at close range can be hip shot with pretty damn good accuracy, especially pointing at center of mass.
The down-side (very little) to that, is that the longer the barrel the longer it takes to bring it to bear on target in close quarter.