myokeeh Apologies for the delay, MS recently updated the App Installer package and renamed AppInstallerCLI.exe to winget.exe which meant a re-work of the scripts. I don't have the full documentation for this but please take a look https://github.com/BeastleeUK/IntuneEndpointManager for my Github files. It's based around code from CodyRWhite who also has a great packaging and automation solution for your apps. None of this requires the store to be installed or permitted.
You will first need to deploy the Install-AppInstaller.ps1 as a Win32 Package, using the detection script. This will grab the latest version from MS and install it for all users, including SYSTEM.
You can then keep using the Manage-WingetApp.ps1 as a reusable Win32App for each app you can get from the store or the repository. There's a few parameters to pass that you can see in the script help so the same script an be called for install and uninstall. I haven't tested the overrides yet but they should work. You make the Install-AppInstaller package the dependency so it is already in place and apply appropriate detection rules. You can deploy user only by selecting a user scope in MEMAC and using the -scope user parameter when calling the Manage-WingetApp script. CodyRWhite has a really great solution using the winget list command that you can modify for each package as a custom detection script. You can see his code https://github.com/CodyRWhite/IntuneWin32AppDeployments.
Finally you can automate the update of the installed packaged, I haven't deployed it yet but there's https://github.com/Romanitho/Winget-AutoUpdate, just don't let it do all your apps at once!
DM me if you want details.