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?
For when you have multiple accounts, yes.