Yes but under the new laws neighbours or hotel receptionists have the right to report illegal activities happening in their hotel/building and cops are supposed to respond to complaints and intervene to stop the crime
Which is a lot easier to type than to accomplish. While a hotel has a certain right to allow entry to rented rooms, your neighbour has no such right, and hotels must be wary of interfering with your Charter protected expectations of a certain level of privacy. Police who entered without other evidence than a complaint would have to collect proof of the couple having sex (part1) in exchange for money (part2). Without self-incrimination, that would not be easy.
In jurisdictions where commercial sex has long been illegal, police have found that sting operations give them the biggest catches at a cost their budgets can afford, but they also rely on well established legal precedents that closely define what constitutes a criminal offer to or from the provider. We don't have such case law, and as the experience with drunk-driving has taught us, any law that tries to set a level beyond which ordinary acts become criminal also gives the defence bar a large monetary incentive to parse the definitions and specifics of the law to the
nth degree.
I'd suggest that the cops were basically content with the old law, as was society, but when faced with having to draft a new one, CPoC couldn't resist overdoing it to please their law'n'order rump. As before, I'd expect there to be little or no controversial enforcement — protecting underage kids and stopping forced/trafficked pimping was always OK, and still is — as long as operators stay more discreet and orderly than the proprietors of the notorious Bondage Bungalow managed to do.
Not to say that the reactionary CPoC rump will never grow larger and spread into something truly ugly, inspiring politically and ideologically-driven police chiefs to use the law and ignore any social disorder if it serves their agenda.