In power query, there is no way to produce a viable hyperlink as a result. I can at most produce a HYPERLINK expression as text but I need to “edit and enter” for it to change to a hyperlink.

That’s just a specific case of the general case that power query outputs, when being formulas, can’t be autoevaluated whenever the query ends - you can just compute inside the query.