There are definitely some pearls of wisdom in the comments. You are contemplating purchasing and renting out your own vacation home. I know it is an exciting proposition and venture ~ it was for me ~ at least, for the first 7 yrs.
It is also probably true that it makes a difference if one is a “people-person” as @BurmaPark noted (it’s not my forte’) but even so, it can be done successfully as a remote owner and still receive 98% 5-star reviews. (pat-pat-pat!)
There will be stressful moments for sure but it usually works out as long as you keep your eyes on your goals, not the least of which is preserving your investment property. However, going into such a plan with an intended mortgage does not appear wise to me so it is not what I would undertake.
What drives people to do it, you ask? For me, it was to perhaps gain some income on our vacation home while we weren’t there. It was a challenging idea and a new experience in property ownership. I had already managed our long term rentals (aka the “bread-n’-butter”) for years but was intrigued with attracting vacationers to my “personal” space and testing how it would fare.
What do I like about it, what do I dislike? What I like most I guess is that I get such a charge that so many people are willing to pay good money to stay in my place when there are so many alternatives, other rentals. I also like that their reactions/reviews have been so wonderful, many over-the-top, memorable, touching…you name it! To think that their vacation was made so special by staying in my condo is beyond up-lifting!
Is it profitable? For sure! Compared to my long-term rentals, my small one-bedroom brought in 3 (sometimes 4) times as much a month ($39K-$41K year for 7+ yrs.). Not too shabby.
There’s lots more to it, of course, but with all the levels of experienced hosts contributing on this forum, you are bound to pick up and learn volumes.