I have the 16gb surface surface pro 8 and in my opinion the pen experience isn't that good. The 2230 ssd are also really difficult to find and expensive. Also on sale the total package burned a hole in my wallet worth 1.67L, it includes the tab and the combo pen and keyboard.
For me it's quite the opposite. The pen experience is the highlight of this tablet for me, after the excellent keyboard attachment. Granted, I am not using the $100 official Slim Pen 2 but a cheap Renaisser Raphael 530 stylus. The writing and drawing experience on my tablet is same, if not better, than that of my friends' iPad Pro. The
current price on Amazon for the i7 variant with Pen and keyboard cover is 1.43L, altho I am not sure of the seller. An iPad Pro with a Pencil + Magic Keyboard stand will not be much cheaper, whilst losing out on crucial functionality (see below)
Tha main reason I am suggesting a Surface over an iPad is because of
3) App demo, debug and testing (optional)
5) Video editing if possible.
Not sure how much app demo, debugging and testing you can do on an iPad. Plus, for video editing, nothing really beats the ease of a proper computer. Biggest advantage of a computer over Surface is full MS Office support for me, as I can use Excel, apart from RStudio and Python.
But if these requirements are strictly optional and you can do without them, then an iPad may well be better. If the requirements are mainly 1) and 2), then an iPad Air will also more than suffice; I don't see the point of spending more for a Pro for that
As for things that it can do other than media consumption: it's a tablet, it will do whatever you want it to. Writing, media consumption, handling emails etc