Getting Generic SD SPI card readers to work with ESP32-DevKitC-32UE boards
After lots of trial and error for the different SPI sets supported on the ESP32-DevKitC-32UE (3 sets), and Arduino code and library changes, I finally got it working!
For context, the Micro SD Card readers in question are these.

The ESP32 boards are these.

The working solution was with the following wiring configuration.
SPI Pin name / SD Reader Pin name | ESP32 Pin |
CS | 5 |
SCLK | 18 |
MISO | 19 |
MOSI | 23 |
It should be noted that the readers used worked with 3v and 5v even though they were marked 3v3.
The Arduino code simply used the SD library included with the ESP32 board definitions.