Which camera (+ lens) gives the best balance in terms of price and 3DGS quality?

I thought this would be a good thread to explore which camera is the best bet for 3DGS creators. As I understand it, a mobile phone camera is not recommended, and instead you really need a digital SLR (because you can lock various settings across your photogrammetry). However, I have heard that a mirrorless camera gives better results than a DSLR. Mirrorless cameras seem to be very expensive though, so is there an happy compromise? And if you do recommend a camera, what lens would you recommend and why?