I see it as follows:
My idea of a perfect mix is:
Thin film PV on the roof for the elec.-needs.
Accompanied by solar hot water for shower, cloth washer, dishwasher.
Geothermal heat pump for room heat.
That should cover almost 100% of the energy needs and might be somewhat affordable ...the geothermal might be pricy though.
PB