Motion control support on PC is rather rare as almost every PC game uses xinput, and therefore almost every controller will simply identify itself as an Xbox controller for the best compatibility. You basically have to check on a controller by controller basis if and how motion controls can be enabled on PC.

I do know that some of the 8bitdo controllers can be configured to show up as Switch Pro Controllers on PC with working motion controls.

I can't say for sure with 8bitdo but I can say the KK2's motion controls work on PC so long as the emulator has them. I'd assume this is the case with 8bitdo but I can't check as I found the problem I had with them to be the neutral wrist/hand position to be uncomfortable very quickly.

I was aware of the Ultimate C existed and I did supposed it was some sort of “lite” version

Yeah, but just to be clear, it's not just the Ultimate C that doesn't have them. The fourth link above is to a non-Bluetooth Ultimate variant with no "C" in its name; that particular variant also doesn't have Hall Effect sticks.

For me, it was annoying because

at least when I bought mine, haven't checked recently

8bitdo doesn't make a Ultimate controller with an XBox button layout and Hall Effect sticks. You gotta settle for a Nintendo-layout controller. You can remap the buttons in software on your computer, and they apparently sell replacement button caps if you want to make the controller look like an XBox controller, but it's not internally using the XBox layout, annoyingly-enough.

You sound like you're specifically wanting a Nintendo layout, so you probably don't need an XBox layout, but you might still want to be careful that whatever you order does in fact have the Hall Effect sticks.