There has to be a increase in comfort that is obvious to the rider to be worth the fairly substantial weight penalty, unless you just like the pretty leather. For some that extra comfort exists, for some not.

I suspect that some convince themselves that they are more comfortable after a break in period, which may in some cases, I suspect, have more to do with breaking in their bottoms than their saddles. I have found that after 500 miles I am comfortable on just about any saddle that I have tried unless it is too wide or too soft. I thought that the saddle on my Windsor Touring was an exception when I first tried it, but decided to give it a few hundred miles. I wound up using it for the entire Trans America and all my riding since. It never gave me any reason to regret the choice. This despite the fact that the first couple rides I hated it.

I think I could have been equally happy with the saddles that came on my Cannondale road bike or MTB.

Some of this is probably because I prefer a stretched out position and don't typically have too much weight on my hands or bottom, but support most of it with my legs. The more upright you ride and the less you support your weight with your legs the more trouble you will be likely to have with saddles.

IMO there are lots of comfortable saddles that are both lighter and less expensive than the Brooks.