There´´´ s nothing wrong with a good notary. On the contrary, the notary plays an important part in the buying process and can also cost you money if he/ she doesn´t do the job right.
However, for many aspects of the purchase, you just can´t rely on the notary simply because they usually are not at all familiar with the house in question.
Notaries check paperwork, identities and formalities.
For physical checks, valuations and even many legal aspects only detectable when comparing what´s on paper to reality, refer to a professional in that field!
DM me if you have doubts!