I am massively sick of gaming focused boards. I don’t want my board to be “tough” or “mil-spec” or be extra shiny or have fancy-proprietary-auto-overclock. I want a reliable board that complies with all the specs it claims to support. Low idle power consumption would be nice, too.
This is obnoxiously difficult to shop for in the desktop/workstation space.
The PCIe lanes are the worst. You have x16 slots that run x1, you need to check slots with m.2 to make sure an x8 doesn't become x4 if you insert storage. Wait if I plug something into the thunderbolt port my 10g network card runs at half speed? Obviously these are actual physical limitation from PCIe lane counts, but it makes it impossible to search. Just painfull.
My advice to anyone doing motherboard shopping is to read the manual off the manufacture's site before deciding. The pcie lane tradeoffs tend to be in the block diagram next to the contents page.
This is exactly why my comment goes over the head of people who cry just get the basic boards. No, this is why the basic boards for $100 don't cut it. You now need to dive into the technical data and realize that the $100 board seems like a deal for a reason, and suddenly the $300+ category is your only option if you want to get a PC that doesn't run on fake specs.
I'm just struggling to figure out how many people actually need the PCIe lanes for anything more than GPUs and storage, though.
Like, what are you actually connecting your desktop to?
The only reason laptops depend on Thunderbolt is because they have limited internal expansion and need high performance external I/O.
If you need more things than gaming boards offer then obviously you have very advanced needs and can go pay for a workstation board, something like an sTR5 socket Threadripper board.
They exist to partition capability so that enterprises can’t connect all of their peripherals and some ECC memory to get the same functionality for 1/10 the price. It’s not a physical limitation.
Obviously market tiering is part of it and you can play tricks with north and south bridge and pcie switches (which adds cost), but a ryzen board that advertises a pcie 5.0 x16 gpu slot and 5.0 x4 m2 slot only has 4 lanes left to work with from the cpu (i.e the cpus only have 24 usable lanes). Which while you can play with generations to get more lanes it's effectively still 16gb/s. That needs to cover network, extra m2 slots, usbs, as well as the extra PCIe slots.
I don't mind having to work within those physical limits but I do want to be able to search for boards that support N components. i.e 1x 4.0x8, 2x 3.0x8, 4x 5.0x4 . But the best you can search for is physical sizes of pcie slots and then dive into a spec sheet for each one, only to find that the 6 x16 slots only have 1.0x1 of bandwidth each.
What you are asking for is a workstation motherboard, which does exist. Filter by the sTR5 socket for AMD Threadripper chips, for example.
Unfortunately, as far as finding something cheaper than that, you're looking for a product that appeals to a very small to non-existent market demographic.
Most of the buyers who want workstation boards (companies) do not want a computer that requires assembly.
The demographic that builds their own PC is almost exclusively doing so to play games.
Everyone else who wants to use a computer wants a portable laptop.
The good news is that all the complaints you have about gaming boards are mostly cosmetic. There's nothing unreliable about gaming boards. They all support the specs they claim to support. You don't have to use any overclocking features (I don't). They are off by default.
If you want low idle power consumption, what you actually want is a system that has soldered RAM (LPDDR) which essentially goes against the other parameters of what you asked for. You don't want a module desktop PC at all if that's your parameter. What you really want is a mini PC or a Mac mini.
You're asking for a workstation board with low idle power consumption, but nobody who wants that is optimizing for low idle power consumption.
The best system for you is probably an HP, Dell, or Lenovo workstation PC. The good news for you is that these are all over eBay as corporations tend to sell them in bulk when they're done with them in just a few short years. They're reliable, quiet, and have low idle power consumption. Or, you can go with the big workstations that support ECC RAM.