TIL, with a heavy heart, that the browser extension for Bear and the Stop the Madness extension on iPadOS make Safari open new tabs with every link.
It does not at all seem to be related to any of the Safari Settings themselves. It is also not every extension.