Yes, I'd love that too. Unfortunately though, I'm not sure it's possible. After 5 Terminator movies, we've been desensitized to the idea of a cyborg assassin that it is no longer scary just like the zombies in the walking dead.
I mean maybe it's possible but it's hard to envision such a movie.
I think it's all in the execution. I mean we've had countless horror movies featuring devil worshippers and demon possessed nut jobs and yet Hereditary comes along just last year and scared the bejesus out of everyone, lol. So I do think that old tropes can still deliver the goods...if done right.
James Cameron should have just sent the script to Terminator 6 over to the folks at A24 and said "okay what would you guys add to this" and just do whatever they say, lol.