Inspections have never discovered the material issues I have had buying homes. Never. Minor stupid crap, but never the important things.
When we decided to buy our current home it was obvious it was a fixer upper.
The seller was a real estate agent so we figured he would lie to us about everything.
Worse—he probably knew any decent inspectors in the area—an obvious potential conflict of interest from our point of view.
So—we hired an inspector from fifty miles away—way out of market.
We told the inspector we believed the seller was going to lie about everything and we asked him to inspect everything with a fine tooth comb. He agreed and got on his Columbo big boy pants for the task—you could tell he was enjoying it.
He wrote a very detailed and specific report outlining dozens of things that needed to be fixed.
We bought the house (for a good price) and then made every single repair on his list.
He nailed it—missed nothing.
We have lived in the house for more than two decades—no surprises.
On the last house I sold myself the inspector found a cracked main beam, wow what an issue. Luckily my new neighbors set me up with their cuz that did that work, he fixed in the less than a month and the house sold. Plus I got the insurance to pay for most of it.