Of course, it’s a matter of opinion (regarding the sales bonus, not the meaningfulness of the "award") – but just seriously think about it: In 30 (!!!) years you’ll proudly write "KFW40" in your house ad – and do you really think anyone will then check what that big deal was 30 years ago? The zero-energy standard has existed for 20 years by then...
No, that won’t bring you any advantages when selling... especially since the house itself will have lost quite a bit of value (the house, not the land – possibly).
Why does everyone here want to sell a house for a profit? In 30 years I will sell my house because my wife and I have grown old. Can’t or don’t want to climb stairs anymore and therefore decide on other alternatives. Condominium, bungalow, who knows...
And Kfw 40 is best achieved with a prefabricated house provider who specializes in and is familiar with it. For them, it’s a home game and they set a different price than an individual planner building brick by brick. Also, the wall is almost half a meter thick and other things are simply better solved with timber construction. Some of the building materials are used that were developed together with the big manufacturers like Knauf, for example.
Don’t just claim and theoretically make any calculations. Just go out of interest to a prefabricated house provider and have them calculate it for you, then compare your ancillary costs and especially the constantly rising electricity costs. And then say again that it wouldn’t be worth it... Even just the eliminated construction stress is an enormous added value.