Anything that gets your body moving is a great idea. I'd suggest trying them out first, if you aren't any more excited to "play a game" than to "work out" it won't be any better than getting a gym membership. If it's a good enough excuse FOR YOU, absolutely go for it.
Personally, I found the few that I tried to be boring and repetitive. I wouldn't spend the money on a Kinect, myself.