I'm not exactly sure how privileges are assigned, but I can give an example of perspective.
Power Automate Cloud flows are designed to work in the MS365 cloud which includes programs in MS Office and SharePoint, OneDrive. This is great for setting up process flows that will get responses from MS Forms and putting them in a SharePoint list or SharePoint document library.
This is great for organization processes and SharePoint sites. And this is how it was initially designed and created.
Power Automate will easily connect to your OneDrive files, but it will not easily connect to other folder drives or desktop.
Desktop Automate is more for specific tasks that an individual wants to perform. It is more like soft programming computer controls.
My organization does not allow us access to Desktop Automate because it doesn't want employees programming passwords and creating possible security issues. So we are only allowed to use Cloud Flows.
So I guess I'm not surprised that Desktop Automate thinks Sharepoint is a premium connector since it is more for local computer use. While Cloud Flows would be almost useless without access to SharePoint since that is what it was initially created for.