My approach to this game was kind of the same as you. I didn't play it for years but then when it got put on as an Xbox one collection remaster I picked it up with Last Light. I REALLY tried to play it and enjoy it... but just couldn't. I got through the first three hours but it just wasn't my thing.
I might try to revisit it again at some point since its been a few years again.