The best investment in my comfort and upgrading my home was two redundantly configured Navien continuous water heaters. Never worry about running out of hot water ever again. If I’m gone on a trip for 2 weeks my hot water bill is zero. Due to having overcapacity, whenever I have guests staying with me no one ever has to worry about simultaneously using showers or any other hot water at all. I run out of water pressur…
You mention other advantages, but money isn't one. You're limited to 100% efficiency with tankless.
Although an idle hot water tank can waste ~70W (~1.7kWh) of power, this is way more than made up for by using a heat pump. Plus tankless strains the grid a lot more than any system with a buffer built in.