Was coming in to mention this very one, seeing as I made that very mistake… Big Trouble came out JUST AFTER BTiLC, and I -really- wanted to see the later. My big brother took me to see the former. Disapointment? You’re soaking in it.
When renting heart-warming horsey movies for your eight-year old daughter, for Og’s sake, remember: National Velvet, not Blue Velvet.
:eek:
Irreversible & Invincible.
Same for me with Clash of the Titans and (Mel Brooks’s) History of the World. I was eight, and CotT looked like the coolest thing in the world to me. Mom, not speaking English all that great, too me to HotW. She laughed like a maniac the whole time and I was bored to pieces. 
There’s always Hero and Hero. Both are good films, but when you see Dustin Hoffman, you kind of wonder what kind of martial arts he’ll be doing.
You also might want to keep Ghostbusters and The Ghost Breakers straight. And Ghost Chasers might add to the confusion.
I’ve never seen The Bodyguard (and don’t plan to), but mentally I keep confusing it with My Bodyguard.
RotK could be, depending on which fandoms you frequent, referring to either Return of the King or Romance of the Three Kingdoms. (Although some people, for clarity, add the extra T in for RotTK. 
Both The Pursuit of Happyness and Happiness explore the relationship between a father and his son, but…uh…the similarities end there.
I think you might have gotten the links backwards.
(Hey, the one with the psycho killer was way funnier.)
Dreamscape, starring Dennis Quade
Dreamquest, starring Jenna Jameson
My cable company listed in their program guide the movie “Behind Enemy Lines”. The guide indicated that it starred Gene Hackmane and Owen Wilson. The description was “A Navy navigator is shot down over enemy territory and is ruthlessly pursued by a secret police enforcer and the opposing troops. Meanwhile his commanding officer goes against orders in an attempt to rescue him”. Cool, I’d long wanted to see that. So I recorded it.
A few weeks later, when I watched it, I found myself watching “Behind Enemy Lines”, “An ex-marine returns to Vietnam when he learns his former mercenary partner whom he thought was killed is being held by a sadistic general”, which was utter drek.
If the people who put the damned program guide together can’t even get it straight . . .
I’ve told this story before, but it’s relevant, so here goes:
My ex-girlfriend’s mom went to see Leaving Las Vegas because she thought Nicholas Cage had made a sequel to his delightful romantic comedy, Honeymoon in Vegas.
He hadn’t.
Gates of Heaven (loved by Ebert) resulted in Werner Herzog eating his shoe.
Heaven’s Gate (hated by Ebert) resulted in United Artists losing their shirts.
Both films were released in 1980, and dealt with animal-related land-use issues in the Western US, but the resemblance ends there…
I once heard about some disappointed folks who went to see Murphy’s Law instead of Murphy’s Romance.
The Love Bug versus the The Love Machine. I went to an all boys boarding school in the mid 1970s. The school rented films for weekend entertainment, with a student as projectionist. Somebody messed up the order for one weekend, and the non-Herbie flick was the most popular weekend film ever! Nobody complained. Even when, during one showing, reel 2 of The Love Machine was left out completely. Missing plot and dialog? Who cares - there’s nekkid wimmin on the screen!!
This isn’t precisely what the OP is looking for, but it’s a funny story I often tell on myself. I couldn’t believe how many people were raving about Moulin Rouge. How much fun can a movie about a horrific Cambodian regime “remembered mainly for the deaths of an estimated 1.5 million people (estimates range from 850,000 to 3 million) under its regime, through execution, starvation and forced labor” ??
(I had confused it with the Khmer Rouge, of course. :o
Well, of course. Mulan Rouge is the movie about the Disney Chinese princess who becomes a force in Spoutheast Asia before moving to Paris and becoming the toast of the Impressionists.
If you want to see a cute film for kids, starring Fred Savage, rent The Wizard. When I worked at the video store, we had to constantly tell the parents of youngsters not to rent Ralph Bakshi’s very dark Wizards.
Likewise, people wanting a bit of Bakshiesk swords and sorcery would do well not to rent Lords of the Ring, unless they were willing to settle for pro wrestling.
And I have no idea about Working Girl. Wasn’t that a theatrical movie? An IMDB search just turns up a short-lived sitcom starring Sandra Bullock, long before she was famous. Pluralize the title, however, and you might end up with a documentary about lesbian hookers.
Don Ameche? Warren Beatty? Meh, who cares? Heaven Can Wait is a good film, no matter which half of last century it was made in.