For deterence and scaring an intruder off, the sound of a shotgun is certainly the best. However, I'd be a little leery of shooting buckshot in the house, especially if you have other people (such as a wife, kids) or pets around.
As opposed to .38 or .44 mag, i'll take the buckshot.