You'll see an improvement in video mode material. So anything that was recorded as interlaced in the first instance (sport, studio shot game shows and the like, some of the soaps). With HD cams being more and more popular SD video material is less common so it's only the crappier stuff that will get better. Hollyoaks has been film mode for a while, CSI, 24 etc etc all film mode so won't see any difference there. Really it's sport.
Plus, beware the DVDO will NOT be as good at any form of HD processing. And you will have to have the ISF calibration done again. Plus the DVDO won't have some of the more advanced ISF features that the Lumagen does. The calibrator will not be able to do as precise gamma or y/c delay adjustment for example.