A54S is the need of the hour but I doubt they will ever make it because then nobody will buy their higher end models, Given that the Snapdragon 7Gen Processors are only 590k Anttutu vs the Exynos 510k+ benchmarks I’m also convinced that performance wise there could be a slight improvement but not enough to buy one if you already have a A54 - if they give UFS3.1 instead of 2.2 only then it is going to be a viable upgrade.
Flagship cameras are no joke, I had a Nikon with really expensive lenses and the S22U cameras performed well - pro mode was very useful although professional cameras will always have a better post-production capabilities and versatility but outside of a studio they are pretty much a burden.
A54 camera on the other hand, is very good you can even say just as good - for everyday use i would get the A54 as it is the most value. Flagships and mid rangers both have a 3-4 year life span.