The best time to visit Campus Point State Marine Conservation Area would be during the summer months, particularly between June and August. This is when the weather is warm and the marine life is most active, providing a vibrant and exciting experience.