Keith_Hemmelman You'll still be able to hide the Microsoft Store using Group Policy or CSP, so you don't have to worry about users downloading and installing Store apps. With the Windows Package Manager integration in Intune, you'll find, deploy, and manage apps (not just Store apps, but all kinds of apps) from the Microsoft Endpoint Manager admin center, and assign it directly to the user or user group. The process will be the same as publishing any other non-store app that you deploy today. If you are using a different cloud management tool, Package Manager has open APIs that that tool can use to connect, allowing you to find and deploy the aps from there.
If you do not hide the Microsoft Store, then yes, users will see whatever apps show up in their public, consumer Microsoft Store. So recommend hiding it to prevent users from downloading public apps.