App stores for desktop computers have pretty consistently failed except for Steam.

I don't think I've installed anything from the App store on my Mini, instead I have just dropped all kinds of images into my Applications folder.

The Windows store is about as marginal as it can get. My corporate desktop at work is locked down with the Windows store disabled, they made it so I can elevate and do almost anything I need to do as a developers but I can't touch Policy Editor stuff and can't unlock it. I miss WSL2 but that's the only thing I miss. I install all sorts of things for work and just install them the way we did before there was Windows 8.

In the Windows 8 era my home computer always got the metadata database corrupted fror the store pretty quickly even though I didn't use it very much. The only thing I really wanted from it was the application to use my scanner back when I had an HP printer. It was obvious that it was possible to rebuild that database because it got fixed temporarily whenever it did one of the 6 month updates but people I talked to in Microsoft Support said I should nuke my account and spend hours reconfiguring all the applications that I actually use just so I can use this one crapplet. Switched to Epson and they have their own installer/updater that works like a normal Windows application. [1] I don't think the machine I built that started on Win 10 has any problems with the store but all I really know or care about is that WSL2 works and it does.

Microsoft dreams that you might buy games from the Windows store but it has an air of unreality to it. If Microsoft tried pulling Activision games out of Steam you know it would just force them to write off the Activision acquisition earlier rather than later.