Sony did tell you though. It's left to developers to determine how they'll take advantage of the hardware. Generally, you're talking crisper and better quality visuals. It doesn't take a whole lot of effort to demonstrate noticeable improvements either. You're talking from a few days to a few weeks depending on the developer and their aims. And you don't need entire teams or the like. The cost is insignificant.
Having said that, I think there is already plenty of information out there that is going into the more technical mumbo jumbo of how developers are approaching the upcoming titles. Now that may be a little too technical for the likes of you and me, and frankly probably most of the people on this forum, but it's there. And you also do have people on this forum who understand a lot of that stuff, and could likely explain it to you in simpler ways, but there's usually a tendency to overreact everywhere.
This thread, for example, is utterly bizarre. You've got a whole host of misunderstandings based on what people think Tabata is saying, and that's partly his fault for being too straightforward with his words as always, but also them not really understanding what he's saying. I'm no technical wizard (I barely know the terms), but it's pretty clear he's simply talking about taking full advantage of the Pro and he likens it to his aim for a PC version, which is quite different from the approach most developers are taking to the hardware.
In general, no one is going to those kind of lengths. That indicates a significant time investment that seems to indicate a really different version. And you don't really have to do that. (I'm sure if you did, which some developers will eventually, you could probably make something pretty amazing but that doesn't mean you won't be impressed with the other efforts.) I've seen eight Pro titles now on 4K and HD TVs (and that includes FFXV) and the differences are significant and noticeable. That's not just on 4K TVs either, where it's really noticeable, but on HD TVs where the image is visibly crisper and sharper, and just looks a lot nicer. Most of these titles are yet to be complete too (barring Tomb Raider), so it goes without saying that they'll probably still improve somewhat by the time they launch.
Really, the best way to see these is in front of you, and for information online, you'll have to rely on the tech websites to do their analysis of these games. Then you'll know exactly the differences and nitty and gritty technical details in terms of performance and consistency etc. But in general, I would say it's safe to just expect much better visual quality. That's about the only thing that can be said with any confidence.
There's no rush either really. You have plenty of time to make a decision as to whether the console is worth it for you. There's going to plenty of articles about the Pro games soon so you can make an informed decision as to whether the differences are worth it. And whether you get all the FASA, LOG or whatever other nonsense it is, those articles should make it pretty clear.