Just for interest, just came across this youtube video, the author discusses octopus x v octopus y etc and has made a spreadsheet which among other things calculates payback etc.You need to find the sweet spot between investment and useage. Due to our latitude, we only get good irradiance levels for about 3/4 of the year, and then energy use is far less in summer, so you don't need a massive array to meet self use. Don't get me wrong, if your roof has space for say 20 panels rather than 14 as a single array, then the cost is worth it by the time you've paid for the scaffolding etc, the extra panels are not that significant a cost. If you start putting panels on extra roof orientations, a couple here, a pair there, then it's very debatable if it's worth the extra cost.
Also there is a recent Flux video with Garys Duck curve