To see only the lists in your personal storage, select Recent lists > My lists. To see only the lists that you've created, select the All recent lists filter on the right, then select Recent lists I created. This shows you both the lists you've created in SharePoint or Teams, and the lists in your personal storage.

For SharePoint the workaround is to create filtered Views to access the data. SharePoint can store very large amounts of data. It just can't retrieve more than 5,000 at any one time. For Power Apps the workaround is to use delegable functions to pre-filter the data you are using at any one time in your app.