How Powerful Was The Super Atari VCS (The Atari 3200)?

Back in 1981, Atari was working on an Intellivision killer codenamed "Project Sylvia," "Super Stella," or the Atari 3200. What were the specs for this unfinished console and what kind of games would it have had? Let's discuss; H/T to the late Curt Vendel who did so much work in uncovering the history on this.

Links: Jerry Jessop thread about it: https://www.facebook.com/groups/atarimuseum/posts/836375799727005/
Super Stella Schematics: https://forums.atariage.com/topic/156916-atari-ss1000-sylvia/

Rob Zdybel discusses it (about 7 min in): https://www.youtube.com/watch?v=fmqzybUe9m4