Earlier quoted context omitted.
This isn't widely known, but the Magic2 keyboard can be turned into a wired keyboard by simply plugging in a thunderbolt wire. It will function entirely without bluetooth.
I doubt many people don't like the Magic Keyboard because it's wireless, but rather because it has a different key feel. Although I have an A1243 at home and had a Magic Keyboard at the office and didn't feel like there was much of a difference between the two. If my A1243 failed for some reason, I'd probably just get one of those (since buying a mechanical keyboard with a Mac layout is impossible).
Recently bought a Keychron K2. First mechanical keyboard ever (except the older keyboards that came with computers in the 90's/early 00's).
It's pretty great. Bluetooth and wired modes. Has keycaps for Command and Option. Has the media key icons on the function keys.
It also has a switch so you can quickly set it for Windows (and it comes with keycaps for that as well).