Strictly in my opinion , without getting into what devices, etc, generally speaking, it also will fall on if you are a day to day user or power user , your usage , my answer would be yes all day every day.
A quick example I picked up a back up S21 and having the option for 8gb with the snapdragon 888 that phone is still a beast today in 2023 so yes I’m my opinion.
I also review both IOS & Android devices along with google , Xiomi etc and the s22 -S23 galaxy line on paper are def improvement with power management, from gen.1 to gen.2 (S23 ) however the day to day user isn’t going to notice a substantial difference, it’s the power users , pro pictures takers , debugging for development , running things like graphinenOS & a slew of other scenarios , that will appreciate that extra 2gb for 8gb total , and finally in just the way Android works which some may not know , because if that I will always say yes, yes, yes.
Android works differently in its allocation than say IOS , and other devices, galaxy especially. I also use xiomi, google pixel , and so on . I know everyone will have their opinion through their experience which is totally cool, I am not disregarding that in any way,but from a non biased strictly tech perspective and given my profession without giving it away , final answer is yes , pay the money and get the extra power . Does it suck ? Yes , same as storage , from 128 to 256gb is highway robbery , BUT, I personally think you will be happy with doing so. Best of luck !
I just got the s21 5G US version qsd888 thing Is still a beast in 2023 and will get android 15 with security updates, Android 14 is making he rounds as we speak. 👍👍 worth it!