GTA:SA was the last one I really liked. I couldn't even finish GTA IV, and V was somewhat fun for me, mainly due to Trevor. RDR1 was okayish, nothing to right home about.
Honestly, for last 10 or so years, when it comes to GTA-esque games, I enjoyed non-Rockstar games (like Sleeping Dogs, The Saboteur and Red Faction: Guerilla) more than anything they've created.