I started Foundation this year, but haven't really gotten into it. I think you guys are right about it showcasing his weaknesses. For Asimov, I enjoyed The End of Eternity and his multivac short stories. But generally I prefer Arthur C Clarke out of the old scifi writers. I'd like to read Asimov's books on physics and other subjects sometime though.
I just finished moby dick, and I really enjoyed it. It's probably a future re-read. I was surprised how action packed it was, and the prose was just superb.
I didn't personally mind the whale sperging chapters. I found it to be that charming kind of autism when the autist gets really into their special interest, and just enjoyed the ride. I think the most boring part for me was about 3/4 of the book until the final showdown. It just seemed like not much was happening. But it was ultimately worth it, imo.
I'm on a "read the classics" streak atm. Finished Swann's Way and Moby Dick, started Pride and Prejudice but decided it's not for me, and started Don Quixote, which is promising, but I'm not sure I'm up for all 1200 pages of it. Also reading the Brothers Karamazov which is pretty enjoyable but long.