I've been going to Orange Beach down to Panama City (and everywhere in between) 20 ish years now.
It's all beautiful. The spots on that stretch of beach just depend on what you want. Condo/house? Lots to do/more relaxing? Great dining/takeout and eat at your house? It all depends on what you are looking for and how much crowd you are willing to deal with.
The sand is great in all of those locations.
The water can be different though. If you want that green, green, emerald water, keep going East. It happens in Orange Beach, but not that often. It's common the closer you get to Destin.
On it's best day, the water in Orange Beach equals anywhere along that stretch of coast, but on an average day, the further east you go, the better chance of that shockingly gorgeous water that I think is the prettiest you will see in the continental US.
When people grow up going to Texas Beaches, and get to that stretch of the Gulf for the first time, it's funny to watch their reaction. That area of the gulf ruins Texas Beaches for the rest of your life.