> Are there any counterexamples, where an author wrote a book that is more profound than their biggest hit but got overlooked for some reason?

Any reply is going to be somewhat subjective, but All Systems Red is not even in my top 5 books by Martha Wells...