I know Klonoa doesn't, and NSMBWii's may be mild enough to tolerate it (DKCR set off a lot of people though). Monster Hunter as well, though if you have a 3DS/Wii U you might want to wait on Ultimate, especially Wii U as that'll have online play. Rune Factory Frontier also supports the Classic Controller, so that's another one.
Actually, a quick and dirty way to figure it out is to look for a list of games that support the Classic Controller, you'll miss some like a Little King's Story that uses the Wii Remote + Nunchuk but doesn't bother with motion control or even the pointer, but that'd still hit a lot of them. And if you're open to JUST pointer use that may open your options by a lot.