@sil @popey Okay - safe bet is Keychron. Their C2 keyboard is inexpensive, wired, full size, and not all the mumbo jumbo stuff you get with custom keyboards.
https://www.amazon.com/Keychron-Mechanical-Keyboard-Hot-swappable-Backlight/dp/B08CNBBHQ1
@sil @popey Second option I just found: Kisnt KN104. Full size keyboard, has wireless operation, but you can just keep it plugged in.
I own three of the smaller version of this keyboard (KN85), and I am using it right now. It's an amazing keyboard I can't recommend enough. (If I had realized they had a full-sized version of this keyboard I would have recommended it over the Keychron.)
https://www.amazon.com/Wireless-Mechanical-Keyboard-Swappable-Bluetooth/dp/B0FFMRT99D
Buy Kisnt KN104 Wireless Mechanical Gaming Keyboard, 100% Full Size 104 Keys with Number Pad, Custom RGB Backlit, Creamy Sound, Hot Swappable, Bluetooth/2.4GHz/USB-C for Win/Mac/PC (Carbon Black): Gaming Keyboards - Amazon.com ✓ FREE DELIVERY possible on eligible purchases
I understand where you are coming from on this. I think the big thing to understand is keyboards have been going through the enshittification process (to borrow Corey Doctorow's term) for over 25 years. Personally, I started using PC's all the way back with the original IBM PC, I remember keyboards like the IBM Model F and Model M, which were amazing keyboards. (Which, by the way, there is a company that produces the successor to those keyboards. Their Model M style keyboard is priced around $200. Which is appropriate given inflation between the 1990's and now.)
Unfortunately, companies like Logitech, Corsair, Microsoft, and Dell have continually made worse and worse products, while maintaining the same prices. This brought companies like Leopold, Das Keyboard, Keychron and others in with keyboards that were being made with similar quality standards to the old IBM keyboards, but at much higher prices.
But, then groups of makers and hobbyists started making keyboards by hand. They started discovering a bunch of things about the designs, and found ways to make keyboards better than the large companies. These keyboards were even more expensive because they used exotic materials, and were completely hand built.
Now things are coming full circle. There are companies like Keychron, Asus, Logitech (somewhat) and SteelSeries, that are learning the lessons that the custom keyboard community learned, and integrating that knowledge into their products. There are also some Chinese companies like Akko, Epomaker, Redragon, Royal Kludge, and Kisnt that are producing keyboards in a lower price range that (to varying degrees) offer higher quality that your standard Logitech keyboard.
What is tripping you up is all the marketing BS that is accompanying these keyboards. It's like all things tech - try to make the best buzzwords, and to make your product sound special with a bunch of psuedo-technical sounding horse manure. Most of that stuff is targeted specifically at non-technical gamer types who think the latest and greatest thing will make them a better gamer. It's the same thing we see with golfers being sold special (and expensive) clubs, or watch collectors buying $100,000 watches.
IMO - the best thing is to find something that is higher quality than the average $20 eWaste keyboard that you'll be able to use for 20-30 years, while not spending more than you need to. I feel that keyboards in the $50-ish range from companies like Keychron and Kisnt offer that kind of quality, usability, and longevity.
And, besides, if you buy the Kisnt and try it, you can return it if you don't like it. But, I'm going to bet that you will like it. :)