The boss at Blizzard has an interesting interview yesterday where he said the main reason Starcraft Ghost was canceled was due to the sudden boom in popularity of World of Warcraft.
Original plan was the create a spin-off game from the Starcraft series that involved stealth and a 3rd person perspective for consoles (PS2, Gamecube, Xbox). At the same time, Blizzard was working on World of Warcraft but still had enough people to work on both projects at once.
Then Blizzard started to work on Starcraft II which stretched their resources and couldn't get the time needed to fix the issues with SC Ghost development.
When World of Warcraft became a huge success, even more strain was placed on the company so the decision was to kill off SC Ghost while keeping Starcraft II development on schedule.
http://gamrfeed.vgchartz.com/story/8...stant-success/
------------------------------------------------
GameFreak has no intentions of ever making a console version of their Pokemon RPG series since they feel the series belongs on a handheld and RPGs have been more popular this generation on handhelds than on consoles (at least in Japan).
Nintendo usually leaves GameFreak alone when they make Pokemon games so its very unlikely Nintendo will want to push a console project any time soon.