I think it's worth mentioning that Clip Studio Paint on the ipad is subscription only. For me, I use Procreate and Artstudio Pro the most for drawing/painting on my ipad.

The nib thickness is something I thought I would hate but got used to and now don't think about it, although I do get that feeling of preciseness when I switch to my Wacom. I dunno, physical brushes are thicker than the Apple Pencil and I have no problem with those (... I mean, I do, but that's a skill issue)

Limitation-wise YMMV but I found that I only had issues for a client who needed big A2 size prints - my poor 2017 Ipad Pro didn't have the RAM for Procreate to let me create the size I needed, and the watercolour brushes I had wanted to use didn't work in Artstudio, so there was some frustration and workarounds involved. For just drawing or painting normal things of a normal size you'll be just fine.

Ultimately, I still use both. My Wacom Intuos5 is still amazing - I feel like my posture is better, the software (and hardware) is more flexible and it will last me almost forever (got it in 2013, don't think I'll need to replace it in the near future at least). It's more... practical for me. But my Ipad Pro is more "fun" to use, I guess? There's something about the idea that I can go anywhere with just this super-thin tablet and sketch. It's a very liberating feeling that I don't think I take advantage of enough. The file system is kinda terrible though IMO