There are plenty of examples of large-scale wind projects failing due to budget overruns, here's two of the more well-known examples:
https://www.theguardian.com/business/2023/jul/20/giant-windf...
https://www.theguardian.com/environment/2023/nov/01/rsted-ca...
Large-scale solar is less susceptible to these budget problems as the technology is more mature. The problems here mostly centre around power distribution and the unpredictable nature of (PV) solar power where production can go from close to zero to maximum in the span of a few seconds only to drop down to close to zero again after a few more seconds. Roof-top solar has become so popular that the distribution networks are getting overloaded on sunny days. In e.g. the Netherlands those who have roof-top solar power installations are starting to get billed for delivering power back to the network [1,2]. These problems can be solved by installing local energy storage - 'home batteries' - but these are as it stands too expensive to be economically feasible.
I live in Sweden and have a 14.5 kW solar installation on a barn roof. When I installed this I signed a 5-year contract which enables us to sell power back to the network at market rates. I do not expect us to be able to sign a similar contract once this one runs out and will have to consider adding energy storage to the system - this is why I installed a hybrid inverter when I built the system.
[1] https://www.centraalbeheer.nl/artikelen/betalen-voor-terugle...
[2] https://www.energievergelijk.nl/nieuws/bij-deze-3-energielev...