It depends on the motel. Most likely for a few hours each night if he has the time during a hunt. If he ever lucks out and finds people, he wouldn’t be back that night unless they rejected him – a painful possibility for a little guy who travels with a human! Dean gets a bad rep just because of what he is. If instead Sam finds rodents or insect infestations, he will get out of there and stay in the room. (Mice don’t count, Sam loves mice.)