Some games, like Feel the Magic, use the stylus entirely(and the microphone). It's just a collection of bizarre minigames, though.
Mario 64 DS has three control schemes, two of which involve using the thumbpad on the touch screen with one hand and the buttons with the other, the third using the d-pad and the buttons.
Metroid Prime: Hunters uses the stylus in one hand and the trigger button on the other, so it's easy to manage with one hand.
It works really well.