Can't say I've played any of them apart from Moonwalker, which is alright, but isn't a patch on the arcade, which is quite fun.
The Journey arcade looks like it also might be quite fun, but it does also look like a hodge podge of ideas copied from other games, with a soundtrack by Journey (the group).
I've seen videos of the Christina Aguillera "game", I put the word "game" in quotes because it doesn't seem to have a lot of actual game play. It's more of a multimedia product, which was a whole category of products that seemed to exist just because companies needed something to sell PCs with CD Roms, sound cards and higher end video cards. The trouble is, while there were multimedia products that were genuinely brilliant (I loved Microsoft's Cinemania for instance), and I remember seeing a student project that was a brilliant interactive guide to guns and other weaponry that made brilliant use of sound, video and the then massive storage on CD Rom.
The problem was, most of these products (the Christina CD included) seemed like desperate attempts to cash in.
This is an entertaining review of it..
https://www.youtube.com/watch?v=7RVFnXoWIiQ
Never head of the Whitney Houston one, and can't find anything on Google. Bearing in mind the apparent subject, I suspect this is a homebrew game. Can't imagine Nintendo releasing anything to do with drugs, and I shouldn't think Whitney's family would want anything to do with it either.