Have I just never realized that the sockets of video cards are “upside down” when inserted? 😅 Or is this an illusion created by how expansion card are displayed when advertised?

I can’t believe I have been building PCs for five years and never reacted to this before.

The original IBM XT and PC used ISA, EISA, and VESA cards and slots which faced the other direction. PCI and AGP cards flipped orientation partly to ensure they couldn’t be accidentally inserted into the wrong slot, and became the norm as the older slots disappeared from systems.
It was also so they could have slots that were either/or, so you could put either type of card there. Really wish they flipped them again for PCIe.