FEELING DEFEATED- Hysteroscopy

Hello beautiful Glow(ies)-

I am feeling a little defeated & wanted to see if anyone else has gone through a similar situation. Started our infertility testing a few months back. Was told that all looked good besides my left tube being blocked. We decided to go to another doctor and am now being told both my tubes are open, but I am needing to schedule a hysteroscopy. Has anyone had this procedure & had a positive outcome? Any negative outcomes? Was it painful? Any advise helps. TIA ❤