But I am open to ideas.I see this environment as quite challenging to find a deal that will cash flow reasonably well in my area due to HCOL and interest rates (even as somebody with some resources). 

You can also check online resources like BiggerPockets or Roofstock, which offer general CapEx guidelines based on property type and age.These methods should help you perform a solid preliminary analysis.

The only way to answer that in general (whether house hacking in today's market is still a good option) or for a particular property, is to learn how to run the numbers and analyze a specific property to see whether it will be able to stand on its own as an investment when you move out someday.There are a lot of resources here on BP for doing that but I'd just say, make sure the assumptions you're putting into your spreadsheet or deal analyzer are realistic.Make sure the rents (especially for vacant units or pro-forma #s) are realistic by doing your own rent comps; make sure the mortgage rate is realistic by doing some research online and/or talking to some mortgage folks; make sure insurance #s are realistic by getting a couple of quotes for the # of units and zip code / area you're looking in; etc.I hope that helps, and good luck 😊

They have to collect the data, confirm the data, then publish the data for the public.

Specifically, I’d love to know what resources or tools you use to:Track market trends (e.g., shifts in pricing, demand-supply changes).Analyze local or regional real estate data.Identify key economic indicators impacting the housing market.Stay ahead of demographic changes or migration trends.Do you have any go-to platforms, datasets, books, or even strategies that have been especially valuable?

here is a good relevant read https://privatesyndication.club/articles/can-an-rv-park-be-a...https://Privatesyndication.club  may be a good resource for you. 

Specifically:Share your experiences investing in Knoxville.Recommend resources or tools for market analysis.Help me find off-market properties, turnkey rentals, or connect with wholesalers.I’m eager to learn from this community and collaborate with like-minded individuals familiar with the Knoxville market.

Can anyone suggest training videos, books, or other resources that would help educate me on the topic?

With the help of JURNY I am able to instant book guests all day as I collect IDs, selfies, credit card holds and rental agreements on every stay (yes Airbnb and VRBO included)Whatsapp: I use this to communicate with my cleaners.

Lots of methods and resources.