In theory, lithium iron phosphate batteries should last a very long time. That's what I'd go for if you want the best longevity, but they also have a lower energy density and can be damaged if you charge them in below-freezing temperatures. (Presumably all the cars with LFP have smart charging systems that disable regen and refuse to charge when the battery is too cold, and hopefully most of them have battery heaters.)
With batteries there's this weird dynamic that if it last for a reasonably long time, by the time you need a replacement the new batteries /should/ be much cheaper and more energy dense. Unfortunately, there aren't really any companies making 3rd party aftermarket batteries for old cars. Maybe that will change, and maybe the industry will standardize on some generic battery module design. For now, the replacement battery options seem to be a) buy a replacement from the OEM, b) find a replacement from a low-mileage junkyard vehicle or c) reverse engineer the BMS and install an equivalent custom battery constructed from new or used cells/modules, possibly using some kind of custom-fabricated battery box. It'd be great if you could just walk in to any auto parts store and buy a replacement battery pack, but we're not there yet.
Not trying to be adversarial - genuinely curious. I only buy old cars (median is 8 years old), and I keep them for a while (5-10 years), and I often wonder whether EV cars that old would be a decent buy or not.