Essentially, you have 4 Mac "families" that would work just fine:
- iMac
- MacBook Air
- MacBook Pro
- Mac Mini
- Mac Studio (not counting this one, as you mentioned cost is a big factor)
There are pros and cons to each. Before getting too deep into the woods, you'll want to decide if you want to keep using a desktop Mac or change to a laptop. (Back in 2016, I made the switch from iMac to MacBook Pro, and haven't regretted it. In fact, several months ago I updated to a 15" MacBook Air).
The current iMac is available in the 24" display size only. There are rumors of a 32" model in the future, but nobody but Apple knows what's in the pipeline.
The Mac mini would require the purchase of a keyboard, mouse, and monitor, but is a good option otherwise.
The MacBook Pro model is nice, but pricier than the MacBook Air. Unlike the MacBook Air, however, the MBP can drive multiple external monitors, whereas the MBA supports only one external monitor.
For me, I went with the 15" MacBook Air w/16GB RAM and 2TB internal storage when I updated last year. (I've been a Mac user since 1984). Whatever Mac you end up going with, I can't recommend anything less than 16GB RAM and 500GB storage. If your Adobe Creative apps include video, then I'd recommend at least 24GB RAM (that's the max the MacBook Air supports....the MBP supports 128GB RAM).
Sometimes, the peripherals used make decisions easier, too. The MacBook Air, for example, has 2 Thunderbolt (USB C) ports, a MagSafe 3 charging port, and headphone jack. There are hubs available that can expand one Thunderbolt port into several different types of ports if that's an issue.
Anyway...just thought I'd throw my $0.02 worth out there.