This is one of those times when you need to listen to reason and not your heart. Please consider the long term effect. Getting him a room will not solve his issues and you could be putting yourself at financial risk. If he were to cause damage to the room you might be held liable for repair charges.
Also, how long would you pay for his housing, a month, two, three, a year, the rest of his life?
I know your heart is hurting but by paying for his housing is a temporary band aid.
There are also rules at hotels and motels, no smoking, no drugs.
Yes, this is enabling but you can only do what you can live with. Whatever you decide, there is no right or wrong answer but you must consider all the ramifications of doing this.
Dear lady, you need to put your own health first. Please take care of yourself.
This is the fork in the road we as parents come to. We can continue enabling them and allowing them to deplete our energy and bank accounts, or we can stop and choose to take a different path.
Sending you ((HUGS)) and good thoughts.