It really is exciting to see alternative battery systems beginning to see wider commercialization.

I am not aware of sodium-ion batteries for home use, I believe it's mostly for industrial-scale battery systems. I could be wrong though, would be interested in learning more.

In an apartment setting, IMO the current gold standard is LiFePO4 (Lithium iron phosphate) batteries.

I live in Ukraine and we have constant problems with electricity supply (thank you dear russians). At times you have 1-2 full charge/discharge cycles per day on a 1 Kilowatt-hour battery system. Several LiFePO4 systems in my extended family seem to work close to baseline even after 1.5 years (not used daily though).

I have not seen any options for sodium-ion batteries for home use, but this maybe a local thing.

In a more rural/suburban setting, generators work as backup power supplies for most people. Typically only the well off get a high capacity LiFePO4 systems for house setting.

Good old lead acid is still quite popular in off grid and UPS systems, it's still quite cost effective if size and weight isn't much of an issue.