Yeah, it really depends on what you want to do.
When you are saying Power Apps, it's not specific to Model-driven (aka Forms in Dataverse), versus building your own forms in Canvas Apps, versus building forms in SharePoint directly, versus Microsoft Forms, etc.
I have no idea what you did wrong not to see any data, whether the real list has no data, or if you added columns only that have no data.
SharePoint is the primarily used separate from Dataverse, which is the question.
Also to make one clarification. Dataverse doesn't make forms, the Power Platform aspect is Model-driven forms, simply derived by the Data Model behind it.
I've never found it clunky in... 25 years, but hey hehe everyone is open to their opinion, but as it relates to costs, Dataverse licenses versus free SharePoint SP is the way to go.,
Access is ok, it is not comparable to what you can do in SharePoint all up (not even close), but it certainly is a Simplified way to create forms for a smaller load.