it would probably already help if not each and every tab gets its process but rather just for each site.

Add --process-per-site option to Opera (launcher) command line. Check that updates do not reset this command line.