Yes, I hear you there! Other LR users have also mentioned this friction in the Forum in the past—from what I can recall.
There’s even an open request on this exact need: Option for Video link for Video File feature
Hopefully, another user can chime in on a possible browser extension that can load local transcript in the way you’re looking for. So far, I know of none, so it would be interesting to find out.