After watching numerous reviews it appears the mid range Mac Studio, with 32Gb ram, and 1 to 2 TB of internal storage is the sweet spot for cost vs performance.
And no need to buy the best either… lots of video on youtube before you decide which version is the best for you. The modest one with 32GB ram and 1or 2 Tb of storage would be fine for most people. Then all need is external SSD storage.