The draw to you maybe. You're in no position to generalise about everyone else.
The main story to BG2 isn't that complex. Mad wizard abducts you, you escape, rescue Imoen, get back your soul, kill baddie. The story to one is even more bare. You go through 60% of the game before you hear the name Sarevok and 90% before you realise he's the same guy you met that killed Gorion. Nothing drives you as a player to follow the main story, except quest givers and it's a videogame, so why not?
What made them popular to my mind was they were first games that married (for then) decent graphics, with videogame concepts and the world of d%d and Faerun. Done with humour. And, when it came to BG2 great characters. And yes, romance. I remember reviews making a big deal of it back then.
Story wise Planescape Torment and Mask of the Betrayer are better arguably thematically with more player agency, a more complex central conceit. But BG is regarded as more of a classic. That's because BG did other things right too, especially 2. Great battles, puzzles, a great performance from David Warner, a few superb dungeons, interesting enemies.
Overall you have to look at BG as a whole, 2 1/2 games to judge its story. You're comparing this to one act of EA. The story of BG3 is the thing that's got me most excited.
Also, if you rate the romances in BG2, try out Anomen's. You're in for a shock.
I quite like the Shadowheart scene. You share a bottle of wine, looked at the stars and she may or may not confide a bit in you
A lot of people enjoy dnd because it let's you roleplay a character. Kinda sounds like you look down on these types of people.
The core story of BG1/BG2 is simple but delivered in a very solid narrative. The writing and voice acting were very solid and sometimes even stellar. But what really stood out was the political background and all the lore that was detailed for you throughout the world. It made feel you were in a living world. That was the charm of BG1/2 story.
I like the main ideas for BG3, but I feel the writing is off. The characters seem immature with some silly dialogues. I feel that Raphael and Astarion should be menacing but they sound comical.