Doesn't seem like the direction they'll be going in at all. Quite the opposite seems to be the case actually. PKJ has done nothing but talk about how remarkably powerful Jon is, and how he'll be so powerful that he'll be a major player on the power structure of the DCU. And Batman in issue 1030 said that he'd be more powerful than both Clark and Kara.
So rather than the "little guy" (which would frankly be a bit of a false title for someone of Jon's status alone) he'll be a very young man with a lot of power and agency looking for the right way for him to use it.
I can't actually think of a time when DC has committed to a significantly powerful Superman in the same way they have Flash or Marvel has with Thor or Hulk, so this will be fascinating to see.