Zombes mod pack is really useful, you can select the mods you want easily. I would recommend backing up your Minecraft.jar file/Bin before you attempt to install it.
TooManyItems is really useful because you simply click on the item you want and it will be sent strait to your inventory in a stack of 64 (Except signs, etc).
Singleplayer Commands is one of the best mods for Minecraft, there are loads of commands, just go to the Minecraft Forums topic and all the commands will be there.
NOTE: If you are making a map, make sure you use the texturepack!