I got SM64DS and it was a blast, even though I used to play the N64 version every chance I got. The controls on the original DS weren't bad either, I thought they were very good, I'm fine without the analog stick. Now, playing certain parts of the game on a Lite is a bit tricky (but I hear the d-pad should smooth out after a while and the diagonals will kick in properly after a few hours).
Anyway, good game and still fun even if you played the N64 version tons, not sure if you'd still wanna play it if you already beat it 10 years ago as I've never owned it back in the day, just played a little bit every once in a while. Other good games I own that I haven't been able to get at launch (since they weren't out at that time) are Castlevania: DOS, Mario Kart DS, and New Super Mario Bros., incase you wanted some recommendations too.