The problem with The Bureau wasn't the squad based third person shooting mechanics, those were downright excellent and a natural fit for the XCOM IP, (besides, I'm a sucker for anything that makes a series of games more fast paced and intense, which is why I REALLY DON'T like the Zelda idea) the issue was pretty much everything else. The story and characters were bland, uninteresting, and predictable, all in a series that's been known for having a pretty minimalistic story and characters designed so the player can fill in the blanks (though I don't fault any series that is like that for instead going for having actual characters with actual personality with an actual story and in fact prefer it if done well, but doing that badly is worse than not doing that at all) the upgrade system was less than stellar and didn't even remotely resemble the research system the rest of the games have used, and there were no random missions and the ones that were there weren't anything like the missions other XCOM games used. I doubt they are going to continue with another squad based first/third person shooter after the reception The Bureau got but if they did there is a LOT they would need to work on if that was going to live up to the massive potential that the Bureau had but pissed away.
OT: Not exactly "games" but more of the franchise itself but I think Terminator would really benefit from having an Bethesda style open world RPG. It just seems like it would work so well for that universe and Bethesda themselves would do brilliantly at that as they already have experience in massive worlds set in a sci-fi post apocalyptic world.
Pokemon would work extremely well as an Action RPG, as long as the combat system was remotely decent it would improve the games a LOT without needing to alter the formula much at all. Pokemon itself has basically been the Copy and paste Call of Duty of JRPGs for years now and that would really help breathe some life into this incredibly stagnant series.