It depends on the cereal. Frosties/Cheerios/Cookie Crisp are nice when dry, but the likes of Coco Pops, Shreddies or Sugar Puffs are unpleasant or impractical when dry.
At any rate I don't like any cereal that has gone soggy and soft, besides your oat-y/wheaty types, like Weetabix.