use smart contracts to have the funds auto transfer on the day of or the day before a lease comes up
No need to use a smart contract for this, a simple crontab can do it as effctively as a smart contract with less time, then just use a bash script to calculate/send funds, or, you can do a lot more things, without having to use a smart contract.
The idea is great, but i doubt it is used worldwide, i never heard about such hotel/condo renting in europe.