There are many reasons why one would choose AWS instead of VPSes/Dedicated hosting.
Linode should be compared with Digital Ocean. AWS is different, if it's to be compared it should be with Azure or Google Cloud Platform.
AWS sells VPS hourly which can be used via script , as well as a dynamic database system, hourly. They also sell NFS storage.
Linode sells VPS hourly, which can be used via script. They also pool your VPS storage, so you can place most of your storage on a single VPS, which is similar to buying NFS space. They don't have a dynamic database system, but you can place linked databases on VPS via script easily enough.
The area where Amazon wins is where you have a large amount of data you rarely access.
Google Cloud Platform and Azure have a difference where you can actually rent workloads. Amazon doesn't do that. Amazon is closer to linode in that sense than it is to Azure or Google Cloud.
Linode is substantially cheaper, and gives you large pools of free outgoing bandwidth, also.
The only case where amazon wins, is where you have a unusually large pool of rarely accessed data, and a small computational and ram requirement.
Linode also gives you some unusual benefits, such as placing you on boxes with 40gbit incoming connections, incase you get hit with something nasty that you can rate limit and drop. On Amazon, a 10gbit ddos will result in a failed machine. On linode, a 10gbit ddos will result in a CPU spike.