If you like SF you can't go wrong reading all of Asimov IMO. The entire Robots/Empire/Foundation series is fantastic. It doesn't mean you can't also read other, "better" SF either. Asimov's main SF work will take a few months to read at most.
Regardless, stopping at the first book is a good recommendation. Asimov demonstrated he didn't understand what made his own work interesting. Granted mystery boxes are hard, but he took an immediate about-face on psychohistory and retconned any bit of intrigue with rather vanilla stuff. The first book is outstanding.
Lucas and Disney couldn't help but copy even these bad parts of Foundation in the Star Wars prequels and sequels.
I've never understood this. The beauty of recorded media is authors cannot ruin or revoke their work, assuming no actual censorship, of course (copyright can also be a problem). Just ignore the subsequent works if you don't like them. This is the first time I'm hearing about people only reading the first Foundation book but it's definitely worth doing some quick checks before dedicating one's finite time to reading/watching/listening to anything.
Take Dune. After the third book it gets weird. But Herbert was a white man in the 1970s- ofcourse the books become degenerate and druggie.
Even his contempories were better - Bester and Simak run rings around him.
The first book Orwell wrote is pretty good as well. Down and out in paris and london. It's a good picture of life in the slums at the time, and much more raw than other accounts - Orwell seems to have simply recounted his experiences.
It's a bit low for Asimov to just say Orwell was slumming it like a modern hippie. He was slumming it like in the olden days, and starved for weeks.
The film Amélie "Le Fabuleux Destin d'Amélie Poulain" is not a racist screed. In fact it is a hugely entertaining and charming movie I do not hesitate to recommend to just about anyone. Set in Monmatre, the homogeneity of the heritage of both the characters and extras is jarring because Monmatre is just not like that. If you know Monmatre noticing this will crash right through your suspension of disbelief in the story. You will recover. Still absolutely worth the watch.
Foundation is still worth the read despite the glaring and obvious fault.
Your assertion on whether the work is or is not misogynistic is something you can perhaps discuss with someone else. I am sure there are two schools of thought on the point, but it is not at all relevant to this criticism.
Maybe that helps you understand?