I have been to two Pride festivals in my life. My first was last year to Dallas Pride, and I did not enjoy it at all. My friends ended up getting drunk and leaving me by myself with strangers for an hour. And I was sick and so was another of my friends so we couldn't drink and we were miserable. I was the only one sober to drive us home in a shitty van and then everyone FOUGHT in the car. Nothing can be more dramatic than a POS van full of lesbians and gay men.
However, I went to Houston Pride in June this year with my girlfriend and I enjoyed it greatly. I went with her and one of my friends from Dallas, who, ironically, happens to be from the city that I moved to in order to be with my girlfriend. We all had a great time, got drunk, were responsible, and met some great people.
Neither my girlfriend nor I are the "WE'RE LESBIAN DEAL WITH IT!" type of couple, but we do enjoy going to Pride just to celebrate the fact that we do have rights just like everyone else.