The trade off course for STR route is more management/cleaning of guests coming and going/risk of no bookings vs not needing to deal with long term renters months at a time if that once they move in.

What advice do any of you have for having these amenities at a vacation rental?

I wouldn't touch anything outside the urban core. if your strategy is to buy existing and old I'd recommend not to. as a newer investor depending on your liquidity look at build to rent development. building investment properties below market value by 25% and refinancing out of it to do it again. the urban core has tax abatements as well that are 15 years right now you can apply for. that means that taxes will be around $600 to $800 per year. there's cash Flow but the existing inventory market dried up a few years ago in the urban core. local realtors are going to push you to the trash areas like hilltop, south linden, etc because it's the only place numbers work. columbus is great, but remember a tenant who pays $1800 a month is different than a tenant who pays $900 a month. let me know if I can help any other way! 

Same w/ the folks down at planning & zoning, they're super helpful. i'm in knoxville so happy to talk property specifics. sounds like a cool play. you'll be fine as an owner occupant and city STR rules.  

Side Note: I was working as a staffer in Congress at the time, what a wild year.

I agree with @Isadore Nelson, there will be an initial sting due to to the IRA transaction but with quick math at 8% your 60k will generate about 4.8k in year one, in 4 months at 1.3k you've already eclipsed that, their will also be a larger tax for passive income and an initial penalty from the IRS, but it won't erode the 8 month difference let alone the yearly compounding effect.

. - just the inconvenienced existence of fixing up one project at a time.

They aren't in a hurry and I've looked at similar units sold in this neighborhood and they're asking a very fair price.

If the company would not write this policy this way, you may have an issue at claim time. 

Your question of "does the product exist" is a yes, but the better question might be "will the property cash flow at a 1.0X or better at 15% might be the more appropriate question.