I enjoy both and think both should be used when appropriate.
Baldur's Gate 3 massively benefits from turn based combat. It allows for planning synergy between characters.
Skyrim works better in real time because you are only controlling one character.
There are games where you control multiple units in real time that I enjoy, like Starcraft, but I can't think of any games where you control a single thing in a turn based environment for the whole game that is fun for me.