I’ve had mine for a month or so now, and I’m really pleased with it. Really enjoying Procreate for a bit of drawing and lettering – this, along with Affinity Photo (which I’ve not bought yet) were actually driving factors for buying the iPad (along with Zwift…).
I personally enjoy OneNote for note taking, it perhaps doesn’t offer the best iPad-only experience, but I find it’s cross-device capabilities excellent and make it far out-class the competition.
Lightroom is a bit of an (expected) disappointment – I would have hoped that by now Adobe would have managed to bring a bit more of the desktop functionality to the mobile experience in a nicer way. There was a recent redesign of the interface for the iPad (and Android tablets, I believe), but I’m not convinced that this has really improved matters. I’ve not had much time for photography over the last couple of years, but I’ve always been a big fan of Lightroom – I think the mobile experience now (mostly) matches what I would have liked to have seen in a mobile app 3-4 years ago.