Commenting to mention that I've posted an update to this thread at the top of the OP.

Turns out the hardware is fine, and the controller seems to be working perfectly fine in game!

The issue I'm having seems to be really limited to Steam menu navigation within Bazzite's Big Picture "Gaming" Mode.

I can live with that, for now.