One thing worth mentioning: sleep *does* work in certain places. The one place I've found is on New Super Mario Bros DS, in the menu for Mario vs Luigi... There, closing the lid causes the DS to say "bye bye" and *NOT* wake up.
This suggests to me that it's a firmware problem not catering for...