Just get a Mac Mini
You can spec an M4 Pro with up to 64GB or RAM and 8 TB of storage
Small footprint
Hook it up to a 32" or larger monitor, or multiple monitors
Will last you five to eight years, maybe more
It's clear Apple isn't making a 27" iMac, and a 30"+ iMac will likely cost you more than a similar Mac mini setup
iMac is a great product (I have owned two in the M series), but is made for more general productivity / casual usage at this point. There are other options for you
You can spec an M4 Pro with up to 64GB or RAM and 8 TB of storage
Small footprint
Hook it up to a 32" or larger monitor, or multiple monitors
Will last you five to eight years, maybe more
It's clear Apple isn't making a 27" iMac, and a 30"+ iMac will likely cost you more than a similar Mac mini setup
iMac is a great product (I have owned two in the M series), but is made for more general productivity / casual usage at this point. There are other options for you