Best to work out some figures based on cost, expected generation, export proceeds etc, should give you some idea of ROI timeframe.
Your baseline sounds like more like 400w yes, which isn't dissimilar to mine, and this level works pretty well with solar.
You'd do fairly well with a 4kw~ system based on my generation to date, going much higher you sort of need a plan for the excess generation, whether it's battery, or EV charge, or eddi for hot water. If you want to add more stuff later then gunning for a larger system can be a good future investment, as you don't want to mess about with updating things too much once they're installed.
SEG payments for export are fairly rubbish, especially if you wind up on something like Octopus Go where you only get 4.1p/kwh payments, but if you overspec the generation side you could stick on something like agile or cap tariff and get paid better for excess generation (static at 15p/kwh currently).
I can probably give you some idea of how a 4-5kwp system will do with or without a battery, at least for the last few months.
September
Generation: 375 kwh
Solar to home: 195 kwh (52%)
Solar to battery: 153 kwh (40%)
Solar to Grid: 27 kwh (7%)
October
Generation: 313 kwh
Solar to home: 160 kwh (51%)
Solar to battery: 103 kwh (32%)
Solar to Grid: 50 kwh (15%)
November (to date)
Generation: 119 kwh
Solar to home: 71 kwh (59%)
Solar to battery: 42 kwh (35%)
Solar to Grid: 6 kwh (5%)
Summary is that by having a baseline of around 400W and then doing my best to use excess generation when available for random things like appliances, my solar usage from generation is between 50-60% as it's generated. 30-40% gets sent to battery, and then 5-15% I can't use and it goes to grid.
Where the battery comes into it's own is with days where generation is very up and down, this means that the battery smooths everything out, and you can store excess for later or take advantage of time of use off-peak tariffs like Octopus Go to boost overnight.