I stayed at the CP and was very disappointed by the noise levels. I would have thought an airport hotel would have had much better sound-proofing.
So, next time I tried the in-terminal transit hotel. I found it very quiet. It is very minimal, but it's clean with a nice bed and a shower which is all I wanted.