Not that the 'gameplay' in visual novels is bad, per se, but rather that it doesn't really exist save for clicking repeatedly to move the text onwards. Visual novels account for some (obviously not all) of my favourite games at the moment, and they as a medium are held up purely by story. So yes, I'd say so.
Otherwise, it depends. I couldn't get into the latest Prince of Persia game at all purely because of the gameplay (the demo, admittedly, was all I played of it, but it was still enough to put me off getting the full game), whereas I greatly enjoyed exploring the storyline of the first Assassin's Creed game even though the gameplay was exceptionally reptitive and rather boring (the parkour was all that kept it going in gameplay terms, and even that was slower and clunkier compared to the sequels, which thankfully improved obscenely well to the point that the series is one of my favorite current game franchises)...
Otherwise, it depends. I couldn't get into the latest Prince of Persia game at all purely because of the gameplay (the demo, admittedly, was all I played of it, but it was still enough to put me off getting the full game), whereas I greatly enjoyed exploring the storyline of the first Assassin's Creed game even though the gameplay was exceptionally reptitive and rather boring (the parkour was all that kept it going in gameplay terms, and even that was slower and clunkier compared to the sequels, which thankfully improved obscenely well to the point that the series is one of my favorite current game franchises)...