As others have said, there is no one right answer.
Although I think the obsession with control interfaces is counterproductive. The point is not really about whether you have to press a button each time you want to attack or not, or stuff like that, but rather what feeling the game is designed to produce when you're playing it.
I like Souls game style combat because it feels weighty, it relies heavily on learned skills and knowledge, which I appreciate (although as a scrub, I also appreciate that there are noob-friendly strategies built into that as well) and its unforgiving nature ties into the game experience and creates a fun (for me) feeling of anxiety.
I like the combat in games like Dragon Age Inquisition or Kingdoms of Amalur because while both are fairly simple and forgiving they're also quite relaxing. I play those kinds of games when I'm stressed and need to calm down by just aimlessly roaming some fantasy wildness and just get into the groove of finding and hitting things and getting that skinner box feeling of progression which RPGs do so well.
Skyrim is a weird one because, as you say, you're not really playing Skyrim for the combat. In fact, Skyrim doesn't do a lot of things particularly well.. but it does a lot of things. The appeal of Skyrim is that you can do pretty much whatever you want within the fairly extensive mechanics of the game. You can fight monsters or you can sneak past them and never get in a fight, or you can charm them and make them fight each other for your amusement. Again, Skyrim is one of those relaxing games, although I wouldn't say the combat specifically ever hits the "flow" of the games above.. the relaxation comes from the exploration itself.
I can't actually think of any really good turn based tactical RPGs at the moment. I wouldn't say the old fallout games, for example, actually had good combat.. It was sort of passable for RPGs at the time but basically came down to trading HP until one of you fell over. Generally, I'd say the same of most modern Fallout-likes as well. However, if you had a turn based tactical RPG which actually felt tactical and had interesting mechanics, I'd be down with that too.
I initially wrote here that the only concept I think has aged rather poorly is the whole isometric real time thing.. and then I suddenly realized.. Dragon Age: Origins kind of used that system and while the balance in that game was janky as hell I loved it there even without nostalgia. So it's not true I guess, those can be cool too.
I do think the infinity engine RPGs are a bit overrated though, and while I would still place Planescape Torment or Baldurs Gate 2 very highly in my "best RPGs of all time" list it's.. uh.. it's not for the combat. The infinity engine seems to be having a bit of a revival at the moment though, so I might be in the minority there.