Yeah, the link is more often than not useless because the differentiator is going to be cut off in the ui most of the time. Coda.io has a really good implementation worth taking a look at, where the link has formatting options, but you can also combine the link/url field with a button for a more custom presentation.
Display options
Card
Or, add a button column, and choose open hyperlink. Plus, you can dynamically set the button text via a formula.
You can even use a formula to set the button text and whether the button is enabled or not.