Please elaborate. The only one of those I have any problem with is Rope Trick.
Sleep: Will save or fall asleep for 1 minute/level. Capped by HD (4HD of creatures can be affected in all) but absolutely deadly at first level. An standard MM orc warrior has a will save of -2, whereas a first level wizard with 16 Int can have a save DC of 14, which means that an orc has to roll a 16 or better to resist sleeping. This is a 25% chance of success.
So, if your level 1 party is attacked by four MM orc warriors, your wizard has a statistically good chance of shutting down most, and possibly all, of them with one spell.
Or maybe he casts
Grease. It affects a 10ft square, and forces a reflex save to avoid falling down. The default orc warrior has a reflex save of +0, so he has a better chance of making the save for Grease than Sleep. However, Grease demands a reflex save each round for people standing on it to avoid falling down. Grease can also target a weapon, forcing a reflex save each round to avoid dropping it.
One thing Grease has going for it over Sleep is staying power: At level 10, Sleep is useless against most enemies you encounter, but many of your foes will have pitiful reflex saves and/or balance checks, Such as a
Stone Golem. Yeah, I know it's supposed to be the bane of casters, but it falls on its face when greased, and its Spell Resistance does not help because Grease is a Conjuration spell and ignores SR.
Can you get that much mileage out of Magic Missile, Shocking Grasp, or Burning Hands?
Glitterdust. An AOE spell with a 10 ft radius which forces a will save vs being blind for 1 round/level which also reveals invisible creatures. It ignores SR, and is not a mind-affecting spell, so it's really hard on creatures without good will saves and extraordinary sensory capabilities. Hydras, for example, really don't like to be blinded. Dread Wraith's don't care so much.
Alter Self. Due to the wide variety of 5HD or less humanoids published, you can find many useful forms. In core, for example, you could turn into a Troglodyte to gain a +6 natural armor bonus to AC, a Merfolk for 50 ft swim speed, the ability to take 10 on swim checks, a +8 bonus on swim checks to avoid hazards or perform special maneuvers, and run while swimming in a straight line, or any other creature you might want to be disguised at. This spell is very, very versatile.
I have to take a break to work on tris(pentafluorophenyl)boron, but I hope this has answered some of your questions?