One surefire method to stop automatic updates is to remove execute permissions from Opera's opera_autoupdate executable. This prevents Opera from ever checking for updates. Run this command in a Terminal window.

chmod a-x /Applications/Opera.app/Contents/MacOS/opera_autoupdate

Restore update checking with this command:

chmod a+x /Applications/Opera.app/Contents/MacOS/opera_autoupdate