For personal use, Google Drive creates a way for me to have automatic backups of files I wouldn't want to lose in case of drive failure. It's also a way to easily share files between my desktop and my phone.

For professional use, I've usually seen it used as a document repository that can be shared by teams.

In both use cases, 5 million files seems like it'd be a hard limit to hit.