Pretty cool how certain everyone here is that it will "never" pay off. As if everyone had swallowed a crystal ball.
You assume rising energy prices. I do too, if only because of inflation. The electricity price is formed mainly from taxes, less from changes in producer prices. With gas, it's different; this is a globally traded commodity and depends on the oil price. Very prone to fluctuations and currently at a low, so many think it's a good deal for the next 30 years. We'll see. 60€ gas can quickly become 100€ gas.
But you also note that insulation is at its limit and want to focus more on the system technology. I don't see it that way. The usual insulation material in functional walls is EPS and has at best a WLG 032, usually 035. Mineral insulations lie between 040 to 035. However, there are already vacuum insulations, the current cutting edge, which have WLG 007 to even 002. They are also available on the market but quite expensive. But: They are a good factor 5-10 thinner than comparable insulation. In the functional wall, this means that the KFW 55 standard can be achieved with a wall about 20-22cm thick compared to a 35-37cm thick wall. That is a massive gain in living space, which can be equated with money accordingly. More insulation reduces the heating load of the building, which is why heat generators can be designed smaller. Saves money in the investment, e.g. smaller heat pump, shorter geothermal drilling (if applicable). The facade also outlasts any system technology and will not be changed quickly. In 20 years your heat generator will be broken; then the insulation will again make itself noticeable in lower investment costs for the heat generator. Just a suggestion that you cannot reduce the topic to "Today I pay 60€ gas, you 50€ electricity."
Regarding funding, that is individual. We have to build KFW 55 here anyway (or at least reach that level, not necessarily go through the KFW program), in this city there is nothing else anymore in new building areas. Controlled residential ventilation is a given anyway, the leap to Kfw 40 is a small step if you simply put 2-4cm more insulation on the functional wall. So it can be worth it. For two residential units, the subsidies double, so it can be even more worthwhile. Some also find the KFW loan conditions good since they are independent of credit rating, unlike bank loans. In fact, KFW conditions have not been very interesting for us since the beginning of the year, so we will forgo KFW certification and thus the KFW loan and subsidy. But that is just a snapshot; a year ago it would have been different.
KFW 40+ costs 40T€. Hmm. There is definitely something to that if you consider the "big" jump from the Energy Saving Ordinance to KFW40. 10T€ more insulation, 10T€ ventilation system, 10T€ photovoltaics, 10T€ electricity storage. Roughly. Against that are 15T€ repayment subsidies (for which, as said, the full KFW loan must be taken), already 30T€ for two residential units... energy savings, a qualitatively better house (-> resale value), possibly income from photovoltaics or savings on household electricity, and the incalculable comfort of controlled residential ventilation.