That's how most graphic tablets work though. Your hand and eyes learn to work in coordination. You learned to use the mouse after all, haven't you? Tablets are slightly different but the learning curve is about the same. It's definitely possible to produce highly detailed artwork without drawing on the actual screen.
Relatively small size is not a problem either, since zoom levels exist. The S sized tablets are not that much bigger. In some cases, like photo retouch, small area may actually be preferable to a larger one. It allows you to do less hand travel for the same result. It may be a problem for the more traditional artists though, who use their shoulder more than they use their wrists.
Hover is something Apple would have to work on were they to offer Pencil support of course. But if Wacom can do it with their tablets, Apple can probably do it too. Navigating macOS with a stylus is perfectly fine. I would miss having the buttons on the pen itself but their functionality can mostly be replicated by the modification keys of the keyboard.
