But for literally anything else I think it's ready. Just browsing? Office work (writing/spreadsheets/presentations/email)? Development? Media production? You're good.
For Linux-curious I'd advise to get a dedicated hardware, like 5/7 year old business machine (Thinkpad or even smth like Dell Latitude), they'll be under $300. Don't do Arch (unless you do that for the sake of being able to install Arch). Instead, get Ubuntu, Mint, Fedora, Debian, Zorin (the last one specifically for Windows users), or one of many other beginner-friendly distros, and drive it for a bit. Get the software you want, see if it works for you, and if you don't like it, it's all good. If you do, you can gradually move all your stuff to the new machine, or install Linux on your main machine.
That's what I did (quite a) few years ago when I got fed up with Windows 8, took me about a year, but I've been on Mint Mate ever since. My gaming rig is still Windows 11 but all it has is my Steam collection.
This is an overblown issue. For the most it is a case of installing the proprietary driver package following the instructions for your distro. One more step than AMD which just works, but not really any more difficult than installing another package.
The other one noted if you don't specify the density of plastic for bags, or paper for bags and packing, you get clingfilm thinner than you thought existed, and paper which is almost tissue in its weakness. You don't even get boxes to put the boxes in, if you don't specify boxes to be delivered in boxes. So now wrapping a pallet becomes a nightmare if they don't stack. And if you don't specify how many to stack, and how to pad the stack, they won't do unit height stacking if it costs labour time. Your risk.
Some of this like the casting mistake, or the knob thing, could happen anywhere and you have to be close to final manufacture spec to find out e.g. the metal coating impinges on the knob at the free space you specified, because your test rig didn't have powder coating. Or, that a design feature you need like the light entry holes, is used by the casting engineer as pour points because it looked like you'd specified mould pour points not functional holes.
But other things like "yea, you didn't spec how long to make the tails so we cut the tails as close as we could" is just the cheapening above: if you don't SAY its a 10cm tail for the connector, it will be 2cm, if saving 8cm of cable saves money for them.
I've read some stuff which says the cost of 5 SBC boards with pre-applied SMD is now so low, you might as well order 5 so you get at least 1 which works. That means they will wind up working out your tolerance for failure, and produce goods to meet that: if 1 in 5 is viable, thats what they'll target.
I've got suppliers who I can send a difficult part to and know that I'm going to get exactly what I expect, faster and cheaper than just about anyone else. It took a few years to get to that point, but these few vendors make it really hard to go with anyone else, much to the chagrin of the sourcing team who rightly recognize it a risk to rely on just a few suppliers.
Once you get to a certain type of supplier you end up running into the problem where their processes are such that they won't do anything without you clearly documenting it. They simply refuse to make any assumptions on your behalf. They can be so frustrating when you are used to the other way of doing it. I simply cannot answer some questions because I'm so used to my other suppliers just doing it correctly and haven't ever asked about it.