Absolutely not!
A homosexual or polygamous marriage in one state would become an issue if the people moved to a different state. This would clearly become an issue in terms of the "full faith and credit" clause in Article IV of the Constitution.
As much as I would wish for every state to ban abortion, a woman would be allowed to travel to a state which allows abortion. The abortion would occur in one state and the other state's laws would not apply. In simpler terms, some states allow the sale and use of fireworks while others don't, there is no prohibition from someone travelling to a different state and using fireworks there.
If stare decisis is the game the homos want to play, they'll lose; Federal courts have decided on numerous occasions that a provision in one state's constitution absolutely trumps another state's statutory permissions, within the former state's jurisdiction. It can hardly be otherwise, for, were it so, any state legislature could void any other state's constitution in whole or in part by merely passing a statute.
The technical term for such an eventuality, given some sort of ex jure barbaro voiding process like this, is chaos.
So, if Roe V. Wade were to be overturned, it would then go back to the states. This would be better than nothing of course, but I would like to see a Constitutional amendment that would protect innocent human life. If it goes back to the states, then unborn babies in some states would not have a right to life while those in other states would. I think something as sacred as defenseless human life should be equally protected under the Constitution. That's my two cents worth.