Good application of it is not, no. When we hear obvious autotune vocals, it's a deliberate aesthetic choice.
I believe what you're talking about is how modern production is about producing "perfect" song recordings, and mapping everything to a click track/beat grid. Now that is totally noticeable compared to music made a few decades ago. I do agree that it makes music sound sterile. This is separate to autotune/melodyne being used.
"I bet some time from now, could be as little as a decade, maybe two, we will look back at all this and chuckle."
Maybe the main industry studios will, but music in general isn't determined by what those folks are doing. There are more indie publishers than ever, and so on.