For me it's Diablo II. Granted I've played my fair share of D2 since launch, and also recently on a private server with a comrade from hexbear, but I still feel like years later the game didn't grab me as much as D1 did.
Granted I don't hate D2, but for a game that I keep coming back to, D1 takes the prize.
Same here for RDR2. I played it once for a couple hours, and then every time I thought about picking it up again I decided not to because it just took so long to do anything. Go to the camp, get the mission, go to the mission start, get the mission again, go the the actual mission location, finally do the mission (but don't deviate from the Devs' planned path by even one foot or you'll have to restart).
RDR2 had all of Rockstar's worst habits charged up to eleven.
The game is incredible the first time. I want to replay it, but the thought of needing to play over a dozen hours of slow railroaded cutscenes/shooting galleries during the mountain prologue, and then the exceptionally long Guarma chapter, just throws me off ever wanting to replay it fully