HDD vs. SSD: which is right for you?

Have you heard about the new Solid State Drives (SSDs) that are being loaded into more and more computers? How do they stack up against traditional Hard Disk Drives (HDDs) and which is right for you?