While I don't agree that this name is horrible, it is, however, it is such a very overused name in the Spanish speaking world and community that it appears dull. Overall, I think this name should be allowed to stay in retirement for a while until it becomes fresh again after a number of decades.
It's kinda a nice name honestly. Looks and even sounds masculine. The only problem I have with it is that it's very overused in a lot of Spanish speaking areas. Otherwise, I like it.
Juan is a very common name in the Hispanic world that one would encounter on a regular basis as you would a Jose, Pablo, Pedro, Maria or Ana. It is not a bad name at all and I do appreciate this variant of John that is further amplified by its unique spelling and pronunciation.