a direct adaptation of Foundation would never have worked, I've been enjoying the show but I'm not fully sold on how they're doing it. I think they are going too hard into ideas only introduced in the later books (written decades after the main trilogy) that changed certain characters, making those later revelations too obvious and damaging the characters somewhat by doing it, but that's just me having read the expanded asimoverse books recently, mostly it's been fun.
What I would love to see is more isolated original stories in the foundation/empire/robots universe, it feels like an untapped treasure in that regard.