Knew this would be a contentious issue. I agree that shifting weight helps aid steering but not as much as many people think - it does change the centre of gravity allowing a greater contact patch for the tyre during cornering but you won't get a bike to go round a corner effectively at speed without the wonders of counter steering. A good video that shows this well is the no BS (Body Steer) bike - voice over by Julian Ryder!
http://youtu.be/8_5Z3jyO2pA
Incidentally, wall of death is the face my wife pulls when I start talking about bikes!!!