As for the point of having a federal government, I could turn the question around and ask what is the point of having state governments when you could just decide everything centrally. You say "some kind of union", but I think you mean "exactly the sort of union that imposes the particular restrictions on states that I think is important". It's very much an open question what the "correct" set of restrictions should be, and that list has changed over the course of US history, and has different choices in different countries.
…which is the point of Federalism. The point isn’t what I think is important, the point is what we decide collectively as a country. And when such decisions are made, everyone must go along with them, because that’s how we accomplish goals. You can’t row a boat across a river if half the people on it are rowing in the wrong direction. However, if you decide you want to go back to shore, and everyone agrees, then the system should support that too (ie repealing prohibition).
For other stuff that the fed govt doesn’t care about, leave it to the states, and for the stuff the states don’t care about, leave it to the people. 10th amendment.