There’s a turn-based RPG sale/event happening on Steam right now. I can’t vouch for any of those games, but new ones do exist.

As for why they seem to have declined in popularity I can only guess - smartphones happened, removing the need for a home computer from many would-be RTS gamers.