Your .40 cal pistol is virtually worthless at 100 yards.
"Keep in mind, I’m a lowly school teacher with all the buying power of a chihuahua right now...(but I still want to be able to tell an intruder, “Drop the chilupa!”
This is what the poster specified his needs were. I don't think he has rooms with 100 yds between walls, do you?
I am also aware that my 40 .cal is worthless at 100 yds, and I am also aware that my tactical shotgun is worthless at 100 yds, which is why I also own a scoped 30/30 and an AR-15.