For anyone interested, it appears that the following extension has provided me with the tab switching behaviour that I want.
https://addons.opera.com/en/extensions/details/classic-tabs/
Enable "Activate the next tab" under "When closing a tab"
Guess the thread can be closed.