I currently own 6 handguns in .40, if you are going to go that route do some research on the handguns you are interested in before you buy, shoot them if possible.
I have had a few that are not fun to shoot at all.
I carry a shield performance center .40, the ported barrel and slide make a huge difference in “muzzle flip” compared to the regular shield.... my personal experience is the gun will make the difference in if you will like it or not.
I have a buddy that HATES .40 S&W because of the muzzle flip compared to 9mm until he shot a few of mine.... he still doesn’t own one but doesn’t HATE them anymore and said his next EDC will probably be .40