I think with the new OS, you're stuck with the icons on the left (that's no so bad, is it?)
Press the BB menu button from the home screen to show all your icons. When you have an icon highlighted, press the BB menu key again and select hide icon.
Edit: Pizzle beat me to it and I think I mis-understood what you were saying about "auto-hide". Sorry!