Quote from @Zach Edelman:
Are you planning to occupy the property as a 2nd home or as a true vacation home? The lending options will differ based on this: For 2nd home, 10% down is available, but there are restrictions regarding how much/long you can occupy the property. For investment, 20% down is typical with some 15% down options out there but there are restrictions (not sure if this is available for STRs, just LTRs.)
The second home loan guidelines directly state "The Borrower must keep the property available primarily (i.e., more than half of the calendar year) for the Borrower’s personal use and enjoyment"
This means that you can only book it out on STR platforms for half of the year (50% max occupancy), which really sets a cap on your max income.
Check out the Freddit Mac guidelines here if you want to see full eligibility restrictions: https://guide.freddiemac.com/app/guide/section/4201.15
DSCR loans would not have this restriction.