Does anyone know from experience how painful fluoroscopy is?

Not painful. Fluoroscopy is the live visualization of your body with x-rays. No pain is felt. If it is done with probes in the body, that can cause pain. But the visualization is not felt at all.