Has anyone had success hooking up an SD card to the Photon and writing/reading data?

Yes, you can.
SD cards work on 3.3V and the Photon does so too.
But I’d still use a microSD card holder board, just for the ease of use.

Like this

You won’t need the fancy ones with level shifters.