Well, given my own experience, 480p isn't all it's cracked up to be.

And, honestly, if you asked me to do a double-blind test, it's not clear that I could tell you when my TV is in 480i vs. 480p mode, while the deinterlacer occasionally screws up in noticable juddering ways.

The correct answer, of course, is progressive DVD at 24fps. Once/if they standardize on a format like that, the players will start supporting it and doing the 3:2 pulldown or whatnot inside (and/or TVs will start supporting some multiple of 24fps as their raw input).