Peter
Full time employment: Posting here.
My wife used to use a Microsoft Surface tablet computer. It worked pretty well for what it did. However, like many notebook or tablet computers, it is not the same as having a fully functional laptop. Tablet computers don't always run all the software that a laptop can run, and she found this frustrating.
I suspect this must have been the first Surface, the RT. Indeed, this did not run all conventional windows apps. But from Surface 3 onwards, Surfaces have all had the full Windows 10 OS and have run all Windows apps. (Admittedly, something like Photoshop on a Surface 3 was pretty slow, but it did run.)
I use a 2017 Surface Pro 5. It runs Photoshop, Lightroom, and pretty much anything I throw at it. Really, it should be viewed as an ultraportable PC rather than a tablet. Yes, it can be used as a tablet, but if that's all you need, you should probably get an iPad, and accept the limitations of iOS.