If recoil is a concerned, then I'd say go all steel for a .40 S&W or go with a 9mm in the Rami.
I own a CZ Rami and a of other CZs. The Rami is great in 9mm, shoots like a fullsize, I love mine and it would make a good concealed carry sized pistol for CZ fans...that's how I use mine. Controls, recoil and handling will feel a lot like your current pistol, but in a ligther package for concealed carry. In .40 S&W, I don't know. I have a P06and like the way it handles, it's definitely more recoil, though and I wouldn't want it any lighter. My all steel Witness definitely handles the .40 S&W better, though.
Subsonic loads definitely take a lot of snap out of the .40 S&W, too bad the supersonic 165 and 155 grain loads are so popular, the increase in velocity and powder charge really make them very snappy, especially in a polymer handgun.
If you like the P-09, then you may want to stick with that pistol in .40 S&W. The SIG 2022 is a lot like the .40 S&W version of the P-09. The Sig is fine if you want to buy something a little different, but isn't much different than what you have already. It's roughly the same size and weight as your current pistol, the Sig is going to fill the same niche, just in a different caliber.
If you enjoy shooting your P-09, then go with an all steel CZ or Sig. Weight will increase, but so will shootability and for a night stand pistol, weight is irrelevant anyway...the heavier the better, in my opinion. The Rami in 9mm is really a gem of a carry piece, I'm starting to prefer it over my P-06.