I have a work profile with several containers inside, so that I can be logged into, e.g. GitHub and AWS, with multiple accounts at the same time.
I also have a primary personal profile, with a few containers primarily for cookie pollution separation.
I've never struggled with the "Profiles have bad UX" complaint, because I created a few different launchers for Firefox: work, personal, (a few others for special purposes like retail sites), and a default profile that launches the profile manager dialog at startup so I can select from a few dozen less-frequently-used (sometimes single-purpose) profiles. I like to keep separate things separated.
This took 20 minutes to set up, 15+ years ago(?) and has been perfectly convenient for me, but I've also recently read that Mozilla is working to improve profile switching.