I have a Governor as well and it wouldn't be a bad choice, especially if you spend a little time with it.
Its size is a bit deceiving, as is its weight. It has a Scandium frame which makes it lighter than it looks but its balance is good and it still handles recoil well. The grip is a RB K frame sized grip and will take your grips of choice there. I have the Houge rubber Mono grips on mine.
Mine shoots the Federal 2.5" 410 #000 Buck load well, and keeps them in about a 4" string at 10 "yards". Ive heard a number of people say that they are underpowered in the penetration aspect of things, but Ive only shot paper with mine so far, so I cant say there. I would think that at across the room distances, they would probably work OK and the spread would be less than 4". No idea as to what they will do in sheetrock. I will say that the 410's are the most noticeable to shoot recoil wise. Its not bad, nor are the 45's, but they are a larger caliber and if the shooter is recoil-sensitive you may want to consider that.
One advantage to the Governor too is, it will take 45acp loaded in moon clips, which allow for a quick and easy reload. My gun also shoots the 45acp more accurately than my 45 Colt loads.
This is mine next to my 4" N frame 625 for a comparison. What youre basically looking at with the Governor is a 4" size revolver. While they may look a little ungainly, they arent. They have a typically nice S&W DA trigger and are easy to shoot well with once you get to know them.
I keep mine in an El Paso "Tanker" with a pouch of 410 and 45acp in clips on the holster. Its a grab and go sort of thing, so you can throw it in the safe while youre gone, and pull it out and keep it handy, ready to go when you're home.
All that said, I still think youre best off with the gun you always carry and always have on you, home or not. The one you shoot best with, and shoot all the time in practice with, thats going to be your best bet all around. You never have to go look for it, and you don't have to think about shooting it, so your hit probability with it is likely going to be the highest.