I played TLOUs in reverse bizarrely which gave me a different perspective and I enjoyed it, but playing the first which has a better storyline I can see the second was ultimately too much of a same and over stretched version and I probably would have had the same frustrations us you.
RDR2 I absolutely loved, favourite game of all time, I loved the length of it and its probably why I am not a fan of COD because you can run through them in about 4hrs, I loved the pick up and play element over the course of a longer time. Also loved the south park skit on it haha
South Park - Red Dead Redemption reference - YouTube
Absolutely loved Far Cry 6 despite slight repetitiveness, was the last game I have completed
I have a love hate relationship with other franchises like Mafia and Assassins Creed, some real corkers in there but some utter waft too, although not played the London version of AC yet and heard its the best of the lot so might try it