I guess you’re just playing the wrong ones, really. The Age of Empires games (specifically 2 remake) have been celebrating a decent comeback and AoE4 was released to critical acclaim. Of course Blizzard won’t release anything worth your time anymore, but not everyone is Blizzard. As for turn based RPGs: They’re more popular than ever and I genuinely don’t know what you’re talking about. Turn based JRPGs are hugely popular and even CRPGs can be hugely popular if done right.
Many fans of RTS and Halo swear on Halo Wars when it comes to RTS on a console. Apparently, they really figured out how to do it right, but I haven’t played it myself.