Putting sites in their own process mitigates against Spectre–like attacks, but it doesn’t do anything for higher–level problems like third–party cookies.
I'd love to drop https://addons.mozilla.org/en-US/firefox/addon/temporary-con..., which automatically assigns a temporary container to any new tab, which plays nicely with the https://addons.mozilla.org/en-US/firefox/addon/multi-account... but uses too much memory (at least from my experience).
Using temporary containers, multi-account containers, site isolation, along with a number of other privacy/security addons such as Umatrix, LocalCDN, and many others, I have not noticed any slowdown.
This on an older broadwell i7 with 32GB of ram.
AdNauseam
Archive Page
ClearURLs
Cookie AutoDelete
Cookie Remover
Decentraleyes
DoH Roll-Out
Don't track me Google
DuckDuckGo
Facebook Container
Firefox Multi-Account Containers
Firefox Private Network
Firefox Relay
Firefox Screenshots
First Party Isolation
Google Container
Google search link fix
Greasemonkey
HistoryBlock
HTTPS Everywhere
I don't care about cookies
Laboratory
Link Cleaner
LocalCDN
PinPatrol
Privacy Badger
Privacy Pass
Redirect AMP to HTML
Skip Redirect
Tampermonkey
Temporary Containers
Trocker
Twitter Container
uBlock Origin
Ugly Email
uMatrix
Wappalyzer
Zoom Redirector
So they do different things, and interaction between the features appears to work without issues.