Distributions specifically built for certain applications…
- Security testing
- Partitioning tool and disk imaging (parted magic/clonezilla — free clones of partition magic and ghost)
- Multimedia editing
- System rescue
- Religious (WARNING: one of the links under #9 may be NSFW)
Some of these come in Live CD form.