I don't know how effective this particular lamp is; I've never used on, etc. However the technology is not pure BS, and there may be (or may yet be) a version of this sort of lamp that will actually work.
Do a google search for 'titanium dioxide photocatalyst'. The appropriate titanium dioxide material, when exposed to light, causes some pretty strong oxidizing reactions (think bleach). This could reasonably work to deodorize room air.
Good post, Jon. I think we were under the impression that the TiO2 was INSIDE the tube. If it's on the OUTSIDE, and the tube gives off the necessary spectrum of UV stated on that web-site, then yes, it's possible the bulb may have an effect. But only on the coated surface of the bulb, (unless it somehow sprays the titanium oxide into the room), surely?