@Karina Oliveira Thank you for reaching out!
This is a tough question to answer because there are many variables that come into play. The best markets for short-term vacation rentals are hard to pinpoint because it can depend on the time you buy, where you buy, and how much you spend. There are studies out there that analyze the best vacation rental markets and the answer somewhat varies based on what is being measured.
I think there is an opportunity for high return in every market. It is often dependent on the home you select. You want to look in a market that has legal approval for short-term rental and draws visitors (are there reasons to visit such as attractions, nearby cities, outdoor life, lake, beach, mountains, etc?).
Short-term vacation rentals are also a lifestyle investment, so if there is somewhere you enjoy visiting, I recommend starting there, it doesn’t have to be completely about the financials.
Nevertheless, where you invest is also highly dependent on your budget. Destin can have very high returns, but you also need a higher budget to enter the market and have a successful vacation rental property. Gatlinburg is on fire because the properties can accommodate nearly any budget and it’s a great place to visit due to many reasons like the rural aspect. Rural or naturistic areas that are within 300 miles from a guest’s home/drivable are popular markets right now due to the pandemic (I don’t think this will change anytime soon). Orlando draws international, multigenerational families for the parks (it's good that your brother purchased a 6bed/5bath home, because 5+ bedrooms is highly sought after by guests there).
I personally invest in short-term rentals in southwest Michigan because I live in the Midwest, it is an area that I frequently visit, we find our returns are strong, and they have approval for short-term rentals .