lots of compounds are neurotoxic when taken in large doses, but completely safe when taken in lower doses. This isn't really surprising
There certainly is recreational abuse with very large dosages, but I don't think it's fair to claim that the majority of users fall into this category.
I always assumed it was a trade off of some temporary fun for x% damage to the body or x% increased chance of disease.