is there any focus(excuse the pun)/direction of Adobe being the leaders in this field? Abode is not cheap and yet I'm finding myself having to consider additional software to sharpen high ISO or cropped photos.
We don't know. We're not Adobe, we're just other Lightroom Classic users who have no clue exactly what Adobe is doing, because Adobe doesn't tell us. (The occasional Adobe staffer to respond in this forum is probably forbidden to speak about upcoming feature improvements).
Do you mean you have already tried the current options, but you need something better?
By current options, I mean the Raw Details and Super Resolution features already in the Enhance dialog box (Lightroom Classic shown below, but also in Camera Raw), or the Super Zoom Neural Filter already in Photoshop. All are AI-powered upscalers that were recently added.