The notary is a lawyer.
No. A fully qualified lawyer, yes, but only in some federal states are there lawyer-notaries at all. There are also federal states with only official notaries.
But in this case, he still acts in the interest of the investor
No, never. A lawyer-notary cannot act as a notary if he has already acted as a lawyer in the same matter.
I would unfortunately not speak of profiting here.
Yes: if the improvement occurs, it increases the value of the asset – and the seller would get nothing of it without the improvement certificate, just because he sells you the property now rather than later.
Higher land use than expected = higher price.
Exactly, that could also happen: garden land has no floor space ratio at all, but after the noble assessment for building land, it can have a higher floor space ratio than, for example, the nearest existing building areas, on which the presumed value was based. You (@ TE) see, such a silly meadow can be a high-performance investment.