Taking this off-topic for a moment, but have you ever played Valkyria Chronicles, Squid? It's a game that effectively combines turn-based tactics (top-down, simplified view) and third person real-time shooter elements, along with some basic resource management between missions and RPG elements. It's a far cry from what you have in mind, obviously, but I think it's a start of what a combined top-down and first/third person hybrid could become.
There's also Source Mods like Empires or Nuclear Dawn that have been around for years now, which have successfully integrated a top-down "Commander" role ingame, one that oversees building placement, vehicle production and resource management and issues orders while all the other players play the game in a first-person perspective. It's an amazing mix, and it's so saddening to see both games dying off because they're such a niche and have reached a stopgap in development, it reminds me of why W3D projects also can't get the break in popularity they deserve.
The original Dune RPG DOS game touches on a lot of things you mentioned in your previous post, as go between first person text-based RPG and a top down strategy sort of display when traveling across the planet. And you've got resource management, troop management... it's a really overwhelming game unless you look some instructions up, hahah