Drag & drop the link into the address bar :^) Wacky, but that's what I do.
The problem with many fancy tab extensions is that they try to have you set a complicated policy and set of rules for modelling how tabs should behave. Instead you usually want some simple sensible defaults, and more agency and control: you want some clue what clicking a link will end up doing, and you want to be able to override that when desired.
Safari did a great thing even early on, it didn't just show the url of the hovered link at the bottom of the window, it told you whether it will open it in the same or a new window, or download it, depending on the modifier keys you were pressing at the time.. So much more of that agency & control than other browsers at the time.
Even today though, its still missing being able to override the link's attributes for opening in another window/tab and force using the same one. Also there's no control in whether a new tab opens to the immediate right of the current one or at the far right.
I'd like to see a browser extension that adds those features. Firefox had a "Open in current tab" extension a while ago but it broke, although choosing "Open" from Firefox's context menu on a link seems to do it at least sometimes, although kinda voodoo since it just says "Open" and you don't know what's going to happen for sure.
UPDATE: I originally lumped LinkThing in among the extensions that have rules but little immediate control, however newer versions of this seem to have lots more control than I remember. Installing it