Username or EmailPassword
The biggest benefits are 3 folds:
- better than ASP which it was competing with at the time
- lots of built in C/C++ extensions
- readily available at webhosting companies
I can see how this was made by one or a few hackers so it started out with some inconsistencies.
The biggest problem is they never got their act together and keep making strange choices and inconsistent APIs.
I've got a feeling a lot of people don't like dynamically typed languages anyway. That probably doesn't help.
Only thing I can add to that is:
Use a webhost that has most of them installed or just ask them. If you picked the right host, they might actually be good people.