Nobody likes a holiday home?? With the weakening of our Ringgit, better holiday within the country...
We call it Homestays in Malaysia? Some places like Singapore, they call it Staycation. Well, advantage would be you can charge premium (and still cheaper than hotel), like RM300 - 400 per night for a 3 bedroom condo. BUT you might not rent your unit out on daily basis. Usually all these homestays, they are only occupied over weekends. So, have to take into account on the days when it's vacant. And housekeeping is another cost you have to take into consideration.
Lets say if u manage to rent out during every weekends for 300rm, a month u can get 1200rm, dont think its enough to cover loan repayment and maintenance since its mainly rented to tourists, some may not take care of the property at all.
Unless its a tourist super-hotspot that u can rent out frequently other than weekends then only its worth investing.