I have got it reliably flashing now after double checking some of the soldering. As mentioned in the last post, the CP2102N soldering has to be perfect or at best it won't work at worst it gets very hot and grumpy. From the outside the solder joints all looked good but when I hit it with hot air and pressed down I got a significant solder bubble that bridged two pads. I also swapped the transistors in the reset circuit because I wasn't confidant the bag was labeled correctly. With those swapped and the cleaned up solder flashing worked right away, flashing at 2M baud, the fasted the ESP32 supports. While flashing did work correctly the ESP isn't resetting correctly after flashing. There could still be something wrong with the reset circuit but this reminds me of a known hardware bug in older CP2102N chips. There is a chance I accidentally grabbed, it was a random single in a bag, quite annoyingly I'm missing a couple of reels from moving at the end of last year, including the newer CP2102N.
Plugging along I verified the LoRa modules where wired up correctly and it appears to be in good shape. This is the first time I've implemented two devices on shared SPI lines and it seems to have worked out. I'll be continuing to rewrite the esp32-lora driver to better handle multiple devices. This will mostly entail moving away from using sdkconfig to determine pin configuration and instead pass that onto the user or application to define.