I always felt that Armageddon occupied this uncanny valley of Hollywood cheese. Too much to suspend disbelief, not enough to be making fun of itself. Always loved "The Core" for being the same sort of film but falling into the second camp.
Don’t forget Deep Impact, sort of a summer companion blockbuster, but which “astronomers said was more accurate”, could feed your Hobbit obsessions, and NASA went on to name a space probe after it!