I'm use to a move-in inspection documenting the condition of everything at time of move-in. 

It's worth the $250.You have a pretty broad and "standard" list of items that you would inspect for sure!

You dont get inspection money back .

.: Its typical for real estate investors to hire a private home/building inspectors to inspect a real estate property before they buy it.

Has anyone dealt with a similar situation and still was able to pass the housing code enforcement inspection (1 / 2 required inspections)?

This can also be triggered if they have kids or what they perceive to be valuables in the home that have not been secured.It can also relate to how you conduct the inspection.

He doesn't say no inspection, he says no inspection contingencies.

Could be self inspection (photos) but it's not uncommon and most are done by third party inspection companies.

A professional home inspection can help you avoid costly surprises by uncovering potential issues before you buy, renovate, or rent out a property.Key Areas an Inspection Should Cover:✅ Roof – The home's first line of defense.

However, some challenges to consider are the additional paperwork, property inspections, and potential tenant turnover.