I've had them too many times. Pain is right up there with a fractured pelvis.
Best thing I got for the pain was a shot of toradol in the er. Amazing stuff. No buzz like some drugs but the kidney pain just disappeared, like nothing was wrong at all. Hope you're all better now or at least soon.