Do you have young children or adults only in your party?
If you have young children, the Menehune Bridge area is great because you can enjoy the cabana while they play there. it is pretty noisy though (rushing water). DD loves playing there, so it was great for us.
If you have adults only, the adult pool would be ideal since it is quiet, and the likelihood of getting one would be good.
The cabanas at the Ka Maka Landing are probably the most desirable for families. They book up fast, so if you are not one of the first 3 groups to book a cabana, you may not even give the option.
The Executive Lanai over looks the lagoon so it has the best view, by far. It just lacks the electricity amenities the cabana has (fan, tv, fridge). You also do not get the dessert platter.
We have stayed in all of the above (except for the adult cabana), and my family prefers the Executive Lanai....mainly for the view. It also has more seating than the cabanas.