IMO -- perhaps some will call me harsh for this -- once a Sorceror or Bard selects a spell, they're stuck with it ... barrign wishes or the like.
Any sorceror worth the name will think *long* and hard about their spell choices, with an eye not only to "right now" but also to "tomorrow", WRT how useful the spellis and will remain.
For example, Glitterdust -- useful at any and all levels, as it will AT LEAST reveal invisible creatures caught in it's area, even when saving throw bonusses are high enough to eliminate the blindness effect as otehr than "pure gravy".
Sorcerors can always use scrolls, wands, and other sources to cover gaps in their spell abilities. Sorcerors with the Elemental Substitution metamagicks can keep even their low-level elemental-damage spells useful for a -long- time (Ray of Frost substituted for Fire damage on a White Dragon -- not much, but in desperation, every net 2d3 of damage helps!).
Any sorceror worth the name will think *long* and hard about their spell choices, with an eye not only to "right now" but also to "tomorrow", WRT how useful the spellis and will remain.
For example, Glitterdust -- useful at any and all levels, as it will AT LEAST reveal invisible creatures caught in it's area, even when saving throw bonusses are high enough to eliminate the blindness effect as otehr than "pure gravy".
Sorcerors can always use scrolls, wands, and other sources to cover gaps in their spell abilities. Sorcerors with the Elemental Substitution metamagicks can keep even their low-level elemental-damage spells useful for a -long- time (Ray of Frost substituted for Fire damage on a White Dragon -- not much, but in desperation, every net 2d3 of damage helps!).