HOTEL DUSK AND 999 MENTIONED
Thing is, they're both super unique, to the point of where I'm having trouble trying to recommend something. I'll throw my two cents here and say
Ghost Trick and
Another Code: Two Memories (also known as Trace Memory). Both are for the NDS, and Another Code in particular was developed by Cing, so it's the closest to Hotel Dusk.
No one seems to have mentioned
Time Hollow yet, that one is also worth checking out. Also on the NDS.
And I will always,
always shill
Nanashi no Game (Me). NDS Japan-only game but an English patch is available (here on the repo, too). Easily the most unique visual novel I've ever seen. Go in as blind as possible, that's the best way to experience it.*
*"Me" is the sequel; the first Nanashi no Game is also translated, but you'd have to patch it yourself