Apart from signing into multiple accounts or isolating pages under the same domain, is there any advantage to using Firefox containers from a security standpoint or do you think that Total Cookie Protection is sufficient for most use cases / threat models?
Absolutely, you could have a container with a cookie exception for a site and always stay logged in while not being tracked trought your whole browser