KOTCS failure has nothing to do with the McGuffin of the film. I had no problem with the aliens and I understood the intent with exploring the '50s era.
Where KOTCS fails miserably is not having any sense of realism whatsoever. The Indy trilogy is full of great stunts performed by real stuntmen live on set. While KOTCS is basically a live action cartoon.