There are YT videos now (almost 20 years after post date), that go through the various Czerny books, now many of them are published by Alfred. The School of Velocity (299) and The Art of Finger Dexterity (740) are standard books for the developing pianist. I have played many etudes from both. The pieces pose technical challenges wrapped in musical elements that make it interesting enough to bear repeated run throughs, which is not something that can be said for exercises (like Hanon or Dohnanyi's Finger Exercises book). Dynamics and good tone need to be applied to these studies, plus, to play the pieces at a good tempo, you need to resolve hand/finger/arm technique problems. Czerny was not a genius, like Chopin, so there's no point in comparing them to Chopin's Etudes. Or Liszt's. Czerny had the student in mind.
I'm interested in exploring The New School of Velocity opus 834. It seems to continue op 299 but with more attention to the LH, and with added challenge. No one publishes it, but it's available on IMSLP.