The compromise is mostly what I oppose. If we're seriously discussing the "ideal" choice, then we shouldn't have to compromise. The only reason I suggested 9mm, is that I don't think it plows through walls quite like 45, but I may be misremembering.
Look at the boxs o truth. I like the test they do
http://www.theboxotruth.com