Lee Pace is God's most perfect creation
You're not wrong
Ok so I haven't watched S2, so grain of salt and all.
Taken in it's own merits, and without considering the source material, Foundation is very well done. As opposed to Rings of Power, which has all the re-watchability of Rise of Skywalker. (Less so, actually, RoS at least has better production values and middling banter.) I could only get through book 1 of Foundation, when I was… 18? 20? It was sufficiently dense enough to not garner further interest at that time. I'll give it another shot sometime though. The point being, I'm not as attached to the pre-existing narrative as a result.
However, I totally understand your viewpoint. Why name a show after something and then completely ignore a core concept of the novels? It's a core concept! That being said, i think there's a difference between doing that badly and doing it good…ly. Well. Doing it well. The difference being a well written story that's internally consistent. That was the biggest sin D and D made with Game of Thrones. They ran out of source material and couldn't write a story that was internally consistent with existing character motivations and personality.
On the other hand, it's virtually impossible to do a 100% faithful adaptation. Even if one could accurately and entertainingly convey internal monologues, there's just so much that can't be done with visual storytelling created from print media. The best I've seen are Lord of the Rings and The Expanse. Amazing art, but absolutely not 100% faithful. And how could they be? How do you present the Scouring of the Shire to an audience that expects to see classic Act Structure and knows the story is over when the Ring is destroyed? How do you turn Dominique Tipper into a 2 meter tall hollow boned belter? And that's okay
Sorry, i got a little distracted there. The point is, I understand your opinion and respect it. I also sympathize with screen writers caught between a fandom and producer. When I watch shows from an IP I love, I try to remind myself of the words of Maximus Decimus Meridius, and I ask myself: "Are you not entertained?"