That's not because the .40 is "short and wimpy," but rather because it's too powerful for the average shooter to manage well.
I don't even know if its actually the power.
Its a higher pressure cartridge than either the 9 or the .45.
The .45 is more powerful and I find I can shoot a .45 better even out of the same gun.
Like I said above, I own a Kahr P9. At the Blue Trails sportsman's show I was able to shoot the similarly sized P40 and P45. I shot the P45 better than i shot the P40. Although I didn't shoot either well.
One other observation. I felt like the 10mm G29 had less snap than a .40 Cal G23. I don't know why. The impressions were not side by side, but separated by a year or so. What I do know is the .40 surprised me with its snap and the 10mm surprised me by having less recoil than I anticipated.
Maybe thats the problem. Expectations.
Another thought has also crossed my mind. Maybe its truly the guns. I recently took in trade a Gen 4 Glock 22. While the recoil was greater than a 9mm, it was MUCH less than previous G22s and G23s I've shot. Maybe its the double recoil spring in the Gen 4s. Maybe since the 29 has always had the double spring, it helped to tame the 10mm. I don't really know. I'm just floating ideas.
One other surprise to me was the full sized HK USP40. I also took this gun in trade last year. Its a big gun with a heavy slide. Again, I was surprised at how much it recoiled. It was not a pleasant gun to shoot. A friend gave me some of his fun to shoot .40 reloads to try in the gun and it wouldn't run reliably.
One big surprise to me was the $150 Hi-Point .40. I took this in trade also. Wow, what a crappy looking gun, but it DOES shoot. Recoil was tame. I shot this gun side by side with the USP40 and I consistently shot the Hi-Point better. Of course the Hi-Point weighs about 2x what the USP weighs, so maybe this is to be expected.
Some observations. I don't consider myself to be recoil sensitive. I can shoot defensive .45 loads quickly and accurately out of both my 1911 and my M&P 45 and I don't find the Buffalo Bore .44 Mag hunting loads to be intimidating out of my 6" 29.
Some absolute truths I know to be true are:
1) I don't shoot most .40s well with factory ammo.
2) My students are universally more intimidated by a glock shooting .40 than they are shooting .45 out of my Les Baer 1911.
Even with all that, I'm still intrigued by the PROMISE of he .40. Its seductive. Near .45ACP stopping power in a 9mm sized gun with 9mm capacity. I think the Gen 4 Glock 22 comes closest to delivering on that promise in reasonably priced, concealable guns.