I’m beginning to think to stop using Pis and instead get an old PC - I don’t use the GPIO pins at all, and I can get one of these for $289 AUD - https://www.ebay.com.au/itm/255608574938
That’s 32GB RAM and a 1TB disk.
An 8GB Pi is selling for $279.
I bought one of the early Pi4 8Gb (£76) and although it runs a bit hot I have just changed it to running from an SSD (£20 + adaptor £3.50). Although they are out of stock at present you can ask for notification when they are back in and they have Pi400s now. Pi Hut.