The cash benefits are just a bonus. 

If you have an office or other bonus space that could double as sleeping area, then you may need to increase your occupancy.

The Euribor is behind the Fed, but rates will be going up soon here.Your point about appreciation is one I've been hearing a lot on podcasts...that it's a bonus and shouldn't be a rationale for buying a property.

Even without the inspection, which most people waive nowadays so its sort of a standard and not a bonus, you still need to get a good appraisal report.

Also this is the last year for 100% bonus depreciation, how much will that cost in cash flow.

The deals I invested in did cost segregations which gave me bonus depreciation and I was able to use these passive losses to offset the capital gains - the only part that requires any "doing" is making sure all of the transactions happen in the same tax year. 

I purchased a SFH in 2022 in my name and am doing cost seg/bonus depreciation = large taxable loss.  

I never expect more, but you know who get's the 1st call back of the day....YOU.....if I got a nice bonus.

There is an accelerated depreciation strategy sometimes referred to as "the lazy 1031" that combines cost segregation and bonus depreciation.

Yes - may potentially be eligible for bonus depreciation.Not eligible for tax credits if it is 100% rental.