(i'm a remote investor) Unfortunately the appraisal came in very high so I'll need to pull comparable sales!

I have a high credit score, good income, and money in the bank, but I have been having a difficult time finding a DSCR lender I feel like I can trust.

This sounds like a high-end neighborhood.

Provides excellent hospitality services and quality cleanings. 

My personal DTI is too high.

I would highly just consider getting your RE License and conduct transactions legally and through a broker, it will alleviate all of this mess. 

Additionally, my debt-to-income ratio is high.

Plus many hotels in the more nature-y places have non-refundable policies in place anyway and their rates are just as high.

Zip code 27801 has, according to this article Where N.C. mortgage holders are underwater on their home loans, a state-high 10.9% of home loans considered "seriously underwater", Q1 2024.

Obviously mounted up high in a readily visible spot "trail cams" work just as well (as a possible visual deterrent), very cheap online.