I use IPSEC router to router VPNs to make branch offices look like they are directly connected to the central network at the central office. (No software changes are need on any computer at either site)
There are also software on a server to software on a client VPNs that can give a single PC access to a remote server.
Both these VPN types have obvious business uses.
VPN services to appear to be elsewhere on the web tend to be used for entertainment. -- I tried to remain child-like, all I achieved was childish.