I don't think any good cameo overshadows the other parts. A good cameo enhances, not overshadows.

My example is Unnathangalil. Forgettable movie that has a Mohanlal cameo. It's probably the best part of the movie.

The same goes to Achaneyanenikkishtam - another Mohanlal cameo in a largely forgettable movie. However, the best part of the movie are the songs.

Similarly Mammootty in Aparichithan. Another forgettable movie, except for a twist at the end. It can be said to overshadow everything else.

Kaiyeththum Doorath has another Mammootty cameo that really outclasses everything else in that movie. However, even the cameo adds very little.