Mission Bay is probably one the most hyped beaches of Auckland, where you can find the youth (not my case anymore) and a some party like environments. It does not mean that even an old guy like can me (I have been old since I was a child, not a fan of crowded and noisy places) cannot enjoy the sunset.