There are two main types of server providers in today's market: those built for developers and those built for sysadmins.
Developer-friendly providers have made it easy for web developers to safely and reliably use servers. By removing unnecessary complexity from their interfaces and APIs, by properly handling low-level configuration such as filesystem partitioning and network interface configuration, and even by orienting their support and pricing toward developers, these providers are the ideal choice for the vast majority of developers.
The most popular developer-friendly providers are DigitalOcean, Rackspace, and Linode.
On the flip side, server providers that cater to sysadmins are not designed for use by web developers. Instead of making it easy to use a server, these providers offer nearly unlimited customizability at the cost of massively increased complexity, the need for the user to have server administration expertise to safely use the server, and higher prices. The target market of these providers are companies with dedicated IT operations teams who are managing hundreds or thousands of servers.
These providers include Amazon EC2, Google Compute Engine (GCE), and Azure.
ServerPilot can be used to manage your VPS from any of these providers.
To determine which provider is best for you, consider whether you have dedicated sysadmins on staff and whether the best use of their time is additional server administration.