Workspaces are for organization. Containers are for security, privacy, and using different accounts at the same time.

true, but you can use them for organization too.

can you point to a more detailed description of how workspaces in opera work?

A simple enhancement would be to change the colour of the UI for each container

there are color markers on the tabs, though it's debatable whether that's enough