West Sussex resort comes last again in Which? survey but local residents and visitors are full of praise