I can't speak to longevity. That said, IMO it's specific use more than one size fits all.
I've been using Geocel lap sealant for sealing between flat panels riveted together. I think it's important to have a wetter lap sealant for good squeaze-out when riveting. I like it, but I don't have any mileage on it. Geocel Pro Flex RV sealant
PRO FLEX® RV FLEXIBLE SEALANT - Geocelusa
3M 5200 is a beast, well known for bedding and caulking on boats. It's often called 'the devil's caulk', or, "what part of permanent did you not understand?" I stay away from it.
3M 4200 is probably comparable to Sikaflex 221. It can be removed with effort, but still makes a good seal. Both of these products are as much adhesive as sealant. I don't think I'd use them between flat panels of sheet metal.
And I'm going to be using a self-leveling sealant for roof penetrations.
I'm also sure you can totally overthink this. ;>)