The M&P Compacts are essentially the same gun between the two calibers. I've swapped slides & barrels between a 40C and a 9C so I could use the thumb safety that turned up on the 9C. On that frame, the 9C is a lot more comfortable to shoot, but being a 1911 guy (my EDC is an Officer's sized 1911), all that really means is that the gun's got a bit more recoil, and is a little slower to put back on target.
I have a full size .40, too. As with the 9mm, the two are essentially identical (I'm not sure if the slide & barrel swap is possible - it should be, but somebody complained

). The .40's almost as snappy as the small 1911's - although a tad less than the Compacts - in any case, easy to shoot. I don't have a 9mm full size, but an ancient M39 is a pussycat, and I would expect that the full sized M&P would be equally pleasant to shoot.
Since you're used to the .40, you will find the 9's a tad more fun, I think, but since they're also essentially identical, there's no challenge there. Just don't tell the spouse/significant other

.... "Look what I found in the safe" almost works here.... (I had a few guns when I got married, a bit over 35 years ago, and inherited a few from a friend. My wife has no idea which are which, or what I bought afterwards.)
(Which was kind of funny one night some years ago when I was cleaning stuff in the dining room. I think I had four 1911's in pieces on the table. Her response was "heck of a jigsaw puzzle".... Kind of funny in it's own way, and it didn't work out as planned, but we had to go buy her a glucose monitor suddenly. I was hoping to go into the drug store and ask for something that the dog could work, but she decided to come with me.... The meter itself and the test strips are fine, but the fool lancet is way beyond her. WAY beyond.... My daughter's a nurse, and is trying, but....)
Anyway, I shall now put on my official Dogbert hat from my position as a Moderator on the Buckeye Firearms Association board, and COMMAND you to go buy more....
Regards,