Years ago, it use to be you wanted to reduce or eliminate grain. Panatomic-X, Technical Pan, T-Max. The first two are long gone.

Now its used to give a certain look and is desirable. Beauty is in the eye of the beholder.