Missing Pieces (1991). I don't think most people even know the movie exists.
Wendel (Eric Idle) has inherited... SOMETHING. His recently deceased relative was a bit eccentric, and revealed nothing in his will except a very vague clue as to the object's whereabouts. Wendel and his friend Lou (Robert Wuhl) attempt to solve the riddle, with little luck. However, they soon discover that whatever the object is, it is valuable enough that an alarming number of shady characters will stop at absolutely nothing to possess it!
I must also mention Cats Don't Dance (1997).
This animated musical is the only movie that was made at Turner Animation before the studio was purchased by Warner. It is the story of Danny, a happy and optimistic cat from Kokomo who goes to Hollywood in search of fame and gets a job at a studio which, unfortunately for him, is run by the villainous child superstar Darla Dimple. Darla hates and despises all animals, and will only give them tiny supporting parts. (Danny, hoping to be the star of a big song-and-dance number, is handed a script page with the single word "Meow" on it.) The other animals at the studio, having long ago given up on their own ambitions, try to convince Danny to do the same - but his unstoppable optimism soon inspires them to take one more shot at the stars.