An Apple hater?

So, Apple aside and looking at other brands; is the keyboard wiring matrix standard?
I see Logitech have some nice keyboards, but the question again is if they will work with a PS/2 port. I dug this out of
Wikipedia on the subject of PS/2:
Conversion between PS/2 and USB
Many keyboards and mice were specifically designed to support both the USB and the PS/2 interfaces and protocols, selecting the appropriate connection type at power-on. Such devices are generally equipped with a USB connector and ship with a passive wiring adapter to allow connection to a PS/2 port. Such passive adapters are not standardized and may therefore be specific to the device they came with. They cannot be used to adapt other devices to PS/2 ports.[citation needed] While combi-devices supporting USB and PS/2 are still available, most USB keyboards and mice in the 2010s no longer come with or even support the PS/2 protocol.[citation needed] Connecting them to a PS/2 port would require an adapter, actively translating between the protocols. Such adapters only support certain classes of USB devices such as keyboards and mice, but are not model- or vendor-specific.
Older PS/2-only peripherals can be connected to a USB port via an active adapter, which generally provides a pair of PS/2 ports at the cost of one USB port.
So it seems the USB to PS/2 adapter plug solution suggested earlier isn't standardized (colored in red above, by me). And with USB keyboards made after 2010 they likely don't contain the combined USB and PS/2 protocol information either.
But what's the deal about the active adapters (colored in green by me, above)? I tried to find some more information and came across the
StarTech USB mouse/keyboard adapter at Amazon for a hefty US$ 82. Apparently it's not the silver bullet I was hoping for, based on one of the reviews. Other active adapters I found were the other way round (allowing PS/2 mice and keyboards to be used with modern USB-equipped computers).