In 9mm I would go with a Sig P226, P228, or a Walther P99.
I've fired three different .40S&W's and didn't like any of them, so I have no idea. I guess a Sig P226 in .40S&W would be okay.
In .45ACP I would pick a Sig P220ST or P220 if weight is an issue.
Rick