A console-based version of Pokemon has been discussed by fans since about 1878 and I think it's definitely something that most people would want to see. I mean, as great as the handheld games are, you can't help but wonder whether they'd be able to be even better with a console version. After all, the Stadium games are basically a way to battle in 3D and not much else. I think that what Ouch! said is true in that such an idea has the potential to be awesome but it could also be a huge flop. I'd have more faith in the former though, to be honest.
Having said all that, even if a proper Pokemon game doesn't reach a console, I'm still more than happy to play the handheld versions because they're as great as they've ever been.