I think most/all hotels would ask for this if you pay cash as they need to keep a register of all guests. Booking by CC allows them to do this without any further ID, but I've seen a number of notices at hotels stating that they need proof of ID if you are paying by cash.
You might get an independent hotel or B&B which might not follow this rule, but unlikely with any of the big chains.