We did this...twice. The first time, we bought a condo in an up and coming area of a large city, and rented it out long term. Our tenant has been there seven years, pays way below market rate for rent, and still, the rent is enough to cover all the costs, with money left over each month. Our tenant basically paid off our mortgage for us. Plus, the area has appreciated by about 10% per year, so our condo is now worth more than double what we paid. Our tenant has been entirely hassle-free and wonderful. Last month, we gave her three months notice that we would be increasing rent by 1% to offset some inflation, and she decided we were charging her too little and raised her own rent effective immediately.
We then bought a cottage in a very popular vacation spot, three years before COVID hit (ie, when prices were still reasonable), with the idea that we could block of several weeks for our own use and rent it out the rest of the time. That was not a good investment. Short-term rentals and Airbnbs are ALOT of work, and because the guests see it as a hotel and not their own home, they’re more careless with your unit. We rented it out for one year and broke even after factoring all of the management fees and costs to replace all the stuff that was broken, ruined, or stolen. I think we had a higher rate of broken/stolen/ruined stuff because we didn’t live on the premises. We currently just let trusted friends and family stay, and they pay about 1/3 the market rate to help us cover the operating costs. We don’t make a profit on this place, though COVID has meant that this rural, nature-y vacation town has become immensely popular, and the value of our cottage has gone up around 50% since we bought it.
In your situation, I would run the numbers carefully, find a place in a good location, and find a good long-term tenant to take care of the place for you while paying you rent.