I've never had what I would call a great ride in the wet. Get too cold to enjoy it. Each to their own
As you say, one of the rides I did that gave me great satisfaction and still does was a Police fitness test ride, 100 miles off road and it rained start to finish, cannot say I enjoyed every mile of the ride but the feeling of beating it was very satisfying.
One of the things I find great about bikes and the people who ride them is the wide variety of getting pleasure from them. Now do not get me wrong I enjoy a sunny ride as much as the next person, but that would really limit my time on a bike if I only rode on those days. Certainly I do not put down anyone who is fair weather cyclist, good on them, far better than not being a cyclist.