This site has a really great comparison of the DVD and HD versions of the Fellowship of the Ring. At DVD resolution, there’s a noticeable difference, but at full resolution, the difference is very large.

Hopefully 1080p LCD screens and projectors will be available in reasonable numbers in time for the PS3 with Blu-Ray arriving in the UK. If so, I may be buying a new TV within the next year.