Larger is certainly better if you want to improve your chances of staying off grid at peak-rate, but the law of diminishing returns applies.
I did consider having a second Powerwall (not possible anyway thanks to DNO edict) but the economics don't add up for our current usage. The ROI would be pushed out way beyond the warranty on the installation. This will change if/when we ditch the 25 year-old gas boiler for a heat pump solution some time down the line. At that point a second (or third) Powerwall (or equivalent) will make much more sense financially, DNO permitting of course.
Right now our house usage idles at around 360 Wh per hour overnight, rising to around 500 Wh per hour during the day. A single Powerwall is quite capable of handling that during the 20 hours of peak rate, with some left over for cooking. On poor solar days, immersion heater and dishwasher run overnight. So even in the darkest days of winter we rarely use peak rate grid - I counted maybe 10 days this winter where the Powerwall was flat before off-peak kicked in, and we're not talking by hours. We only need solar to top up the Powerwall by a few kWh to allow us to be a little more profligate,
such as doing a laundry load or two.
So a larger battery is not always better. Pick something which fits your current usage, and add a wee bit of headroom. My plan is to stick with what I have at least until it has paid for itself (about 6 years to go - not bad, considering it was installed Oct '21).