Skipping most of the comments, because I can predict how this will turn out to be, I'm throwing my two cents on the matter.
The Wiimote was garbage.
With that to boot, I also think that the Wiimote STILL has a lot of potential, especially with the WiiU, but not the vanilla controller, the Motion Plus is what still has a lot of potential.
Metroid Prime Trilogy is, for me, absolutely the best example on how can a First Person perspective game can be highly improved with the Wiimote, though that game used mostly the IR pointer.
Also Okami proved that a game that was basically meant to be played in a slow pace, can be significantly improved upon and even speed up the gameplay a notch or two, though that's another IR pointer heavy game, the accelerometer motions kinda sucked (try to succesfully use the dodge motion twice in a row).
And Resident Evil 4 was much easier with the Wiimote configuration.
BUT there's also Mario Kart Wii and other gimmicky games that couldn't use the accelerometer properly. To me, it's not a matter that the technology sucked, but that as you said, devs didn't know how to implement them most of the time.
Motion Plus improved upon this a lot and I still think it has a lot of potential, but I absolutely agree that not all games are meant for motion controls, just look at Donkey Kong Country Returns, it was an absolute pain in the ass to play with the "NES" style of the Wiimote and the Nunchuck configuration didn't make matter any easier.
I'm glad they decided to implement a more traditional controller configuration (Classic Pro, GameCube controller, etc.), because not every game benefits from the motion controls as Ninty wanted.