Concerns about such things as hospital visitation rights are red herrings. The real goal of gay rights activists is for official and public recognition of gay marriage as normal, wholesome and mainstream. If the little solvable problems were all solved, that wouldn't end the crusade. They want the marriage certificate. Today, many have embraced the notion of justice in the form of gay marriage. A couple of generations ago, gays were persecuted, often even by Christians. Who knows where it will be in a couple more generations? Justice that depends on man's good opinion is here today and gone tomorrow. Some scoff at the Bible as the single standard, but the truth is that there are Biblical principles for treating women and slaves well. The word of God has a way of working itself into men's consciences and causing sin to come to a head.
Today, many have embraced the notion of justice in the form of gay marriage. The claim is that rationality demands it, an odd position for anyone to hold who doesn't believe in God. Anyhow, interesting that rationality has been taking it on the chin even in the halls of philosophical academia for more than a century. That's what happens when God is rejected as the explanation. Philosophers have tried for centuries to derive reason and morality starting with man as the foundation, and mostly have wound up eschewing reason altogether. I believe in a God that created reason and morals. Good luck finding an eternal principle based on personal opinion.
Unfortunately, gay rights aren't analogous to women and slaves. There is nothing in the Bible to indicate that being a woman or a slave is a moral failing -- unlike homosexuality, for which such indications are emphatically present. If you believe in Paul's authority as an apostle of Christ, you are compelled to take seriously his condemnations of immorality. (If you think he only picks on homosexuality, though, think again.)