Moving from MySQL on EBS to a Cassandra cluster on locally-attached ephemeral storage was the first time I was happy with a database on EC2.

EBS is convenient as a permanent root for instances, but for anything that actually uses the disk, it's a pain train. I think of it as a large "pen-drive" for the cloud these days.