Had pretty much the same experience and thought I might have a urinary tract infection. Urine yellow and cloudy. Went to GP and then to lab for complete urine test. Not enough blood in urine for the GP to send me to a specialist.
Also went online to search natural remedies for UTI's.
Need to avoid antibiotics because I have ulcerative colitis.
Info said an acid environment is needed to prevent/cure infection.
Started drinking glasses of water with 1-2 tsp apple cider vinegar (got Bragg raw, unfiltered from the health food store). Also drank cranberry juice and plenty of plain water. After a week of this, urine looks clear.
Returning to GP on the 24th for follow-up.
In my opinion, you should not ignore or mask the pain. Something is going on, maybe with your kidney (I'm no doctor). ER doctors are, in my experience, not necessarily thorough. If possible go to someone who can follow-up with you like a family doctor.
It's probably not life-threatening....think horses, not zebras