How much of a difference is there between CD and HD/Blu ray sound quality?

I have read some people go on and on about the new HD content, do you guys think the fanatism about it is justified?