Recently replayed the "remastered" PS4 version and my take is that you have to approach Dark Souls 2 a little bit differently than the rest of the series. My first playthrough was the Scholar of the First Sin PS3 version (which has the old enemy placements and lacks a couple cool lighting features) and I found it to be a real pain. People kept talking about how much easier it was than the original and I just didn't understand why. The PS4/PC Scholar of the First Sin version is the best way to play it, in my opinion. Still, I find myself dying far more in DS2 than any of the other Souls games due to the sheer number of enemies in some areas, the way invincibility frames work, and some intentional design choices that catch the player off guard.
Finally started to really enjoy the game when I let go of my anxiety about dying a lot. Due to the abundance of bonfires, you never lose much progress, so there's really no point worrying about it at all. You just kind of have to throw yourself at situations, learn a little bit more each time, and try to optimize your route through each area. Granted, it's not really reasonable for a game to require multiple playthroughs for it to seem like a good game, but persistence paid off in this case, I think.
Never had much issue with the lock on, myself (at least not anything I didn't take issue with in the other Souls games). I do wonder, though, if playing as a magic user would change my opinion much. I have done dex builds and strength builds, the latter of which definitely felt like the path of least resistance. If I had to rely on the lock on for magic, that could definitely change my opinion.
Still, if you want to like the game, my advice would be to just put it down for a bit when you get too frustrated. If you've beaten it, maybe give it a few months (or more) and then come back to it and see if your opinion is changed. Out of all the games in the series, 2 is the one I'm much more willing to come back to now because there's tons of stuff I still haven't done or seen, it has some truly great detail in certain areas. Basically, the quality of DS2 is very consistent compared to the other two games, which both have much higher peaks, but also much lower valleys.