Colonoscopy - Prep through Recovery

Hi Everyone: This is my first post in the forum. I have battled migraines since I was 16. I am 50 now and can still remember that first one. I am in the midst of menopause or pre-menopause. I have colon cancer in my family history and decided to have one last week at the urging of my internist. I was worried about the prep and not being able to eat but I made it through with homemade chicken broth, lime jello, lemon drop candies and Sprite/Coke. On the day of the procedure, the doctor asked me if I had ever had twilight anesthesia. I told him I hadn't and that I had concerns about the twilight working for me. I was concerned that with all of the meds that I have taken and continue to take over the years for migraines that it wouldn't work as well and I would feel everything. He told me that he would try it with a normal dose and then if I feel pain or discomfort that I should let him know. I felt discomfort right away and they gave me another dose which helped. I did have one polyp that starting bleeding quite heavily and he had to put metal clips on it that stay there until they basically fall off in several weeks. As a result of that bleeding I was told that I couldn't take any NSAID's and he literally told me to not get a migraine for 5 days after the procedure! Like I have any control over them!! Well sure enough, I woke up on day 2 after the procedure and had a killer migraine. I was panicking because I didn't know what I could and couldn't take. While I was struggling with the pain and nausea I looked up the precautions on my Relpax. I didn't want to make the decision on my own so I called and talk to one of the gastro nurses. She said she wasn't sure about the Relpax but thought it should be fine for me to take it. I urged her to ask a doctor, which she did and he said that it wasn't safe and I could have a clot break loose. I ended up only being able to take Norco, which I don't like to do. I had to take more than I am comfortable with and it was awful. That leads me to today....migraine hangover/Norco hangover, brain fog, nausea. I was told that I have to have another colonoscopy in 6 - 12 months. I feel like I should have been better prepared for this but I had no idea that I wouldn't be able to take my Relpax. Does anyone have any tips for preparing for this or am I doomed for the next one?