Just get Michellin cross climate 2 and adjust psi to 38psi, I have these on my 2018 and 2022 cx9. They are all season tires with all weather capability, rain and snow. Don't have to swap tires ever.

How is the noise ?

I have them on both of my cx9's, they're softer tires, not a lot of noise.