General consensus on here is that plasma is better for SD ... especially in larger screen sizes.
Having said that, I've just invested in a 40" Sony LCD and most SD stuff looks good to me. Some of the cheapo channels look a bit nasty but they also look nasty on my mates 42" plasma ....