Honestly I’d hunt down an M1 11” Pro. I use this daily and there is nothing I cannot throw at it that makes it wheeze. Because it’s a few years old you can probably get a good refurb deal. Apple products as you’ll know are well built and last for years if not decades.

Apples own website has it for $600! https://www.apple.com/shop/refurbished/ipad/ipad-pro-11