The last episode we see of Noah's life demonstrates for us that while Noah is in many ways a new Adam, he is also unfortunately another Adam in that he too, righteous as he was, still sinned against God. So this next Adam reminds us we need to look toward the last Adam, Jesus Christ, and His perfect righteousness.
Was Noah's sin consuming alcohol? Or was it drunkenness? The Bible record indicates there is a place for responsible alcohol use, but that may be more difficult for some people to achieve than for others. So for some people, abstinence may be the best policy. Whatever your conviction on your matter, you should not turn your conviction into an opportunity for legalism, that is, imposing your firm conviction upon someone else, since the Bible does not directly prohibit alcohol use, but rather drunkenness.
Also, Noah's curse was not on Ham directly, but on Ham's son Canaan. So there really is no "Curse of Ham." And the curse itself is not dark skin, as some professing Christians claimed in order to promote chattel slavery.
In fact, the Bible itself is not racist, though people often are. But the rise of Darwinian Evolution did more to promote racism against dark-skinned people than nominal Christianity ever has.
We are all of one blood. We are all one race. We all have the same sin problem, and we all have only one possible solution to that sin problem, and His name is Jesus Christ.