Re: skimpy RAM for flagship
4GB is ample. My Nexus5x has half that and runs Oreo just fine. Also being a Sony, it will come with quality RAM, which is just as important as quantity of RAM.
This could be my next phone. I have always liked the Xperia range, it's leading the way features, close to stock and lack of bloat. They also support them pretty well.