I wasn't really impressed even with GTA V, mostly due to the constant in fighting between Michael and Trevor. The game was just too silly for my tastes and I honestly don't know why this game was so lauded for it's writing.
Keep in mind, Rockstar lost their main GTA writer Dan Houser recently too, which could definitely affect the quality of the story in GTV 6. It's hard to say what GTA 6 will be like, but of what little they've shown of it, I'm not impressed.
The last good game Rockstar made IMO was Max Payne 3, that one I really got into. I started out liking Red Dead Redemption 2, but when the story took a major swing where the protagonist got sick and everyone at the camp started hating on him, not to mention no warning that the camp cook would up and leave, making it impossible to finish camp upgrade progress, I lost interest.