However, we do believe that there are different workloads that require different servers and hardware. For example caching services need a lot of RAM but not much else, DBs need very fast harddrives and CPU, and then there are cases when you just want a bunch of storage and not much else.
This is an area that we are exploring to see if we can begin provisioning different hardware types sometime in 2014 and testing to see if customers like the ability to select a different type of VM with different combinations of underlying specs based on their workload.
If anyone wants to startup a separate uservoice request for that we then upvote from there we can provide regular updates on those projects.
Unfortunately however this particular request is going to be declined because we won't move to a "slider" scale where customers can dynmaically select each component individually, it would just lead to increased costs for customers.
We would recommend using the best size that fits currently.