Depends on the need, I run several different types of VPN's for various uses. There's a lot of usage in the professional sector for VPN's. Be it site-to-site or road warrior, there are so many uses for VPN's that I use, design and work with on a daily basis for clients. Having an encrypted tunnel over the Internet between two sites or devices can be critical, and needs to be done correctly. No PPTP! Use SSL where possible (IMHO). I love IPSEC and OVPN.
I believe the services you're asking about
@Mighty-Lu-Bu is the VPN services that folks buy to "protect" their traffic flow over the Internet. As said above, ymmv and be careful which service you choose as some use weak encryption keys, some easily give away logs, some keep all logs, some keep the minimum required, etc. Depends on a few factors really, and then the need.
It again depends on the need and individual, most folks don't really need a VPN. Some folks might want or desire, or feel they want to hide or protect. But with these consumer service VPN's, your data is encrypted to their server where you connect...which is located in a region/country/city. Your public IP is broadcast as being from that location rather than your home. Some folks use it for location purpose, but services have caught on to most of these VPN services and block them. Keep in mind that the traffic that goes beyond their server is not encrypted unless the session with the service or site is encrypted already.
Another thing to keep in mind is that VPN tunnels require processing overhead to encrypt and decrypt the traffic that traverses that part of the network. A lotta folks turn down encryption levels to increase bandwidth/performance and decrease CPU load. This is counterproductive to what a VPN offers though, the point is to protect and encrypt data. Running lower levels of encryption or weaker types of VPN services (looking at you PPTP), you might as well run without a VPN IMHO because there's enough data that is either being handed off in plaintext, or is a low enough level of encryption that if someone wanted it, the amount of work to get it wouldn't be very challenging in this day and age, you're paying and using something that you're not taking advantage of.
I use PIA still every once in a while, and I cranked up the encryption. Yes my bandwidth isn't 100% what my ISP is rated at, yes my CPU usage goes up, yes my level of encryption is worth it to me when I do use that service. Same with VPN tunnels I redesign or fix, I see so many setup with baseline configs, or low-levels of encryption, drives me crazy.