I'd say it depends what you end target is.
[tldr pre-emption:
If you just want a module, no more than about ten I/O connections plus power, go with the Xiao (see below). You need the Arduino IDE and a USB cable to use it.
eg.
https://www.ebay.co.uk/itm/353410113752 ]
In general, if you want to build something with reasonably powerful custom hardware and based around a bare IC, use eg. a DSPIC33 series IC - up to 512K flash and 48K RAM in the versions we use, and 60MHz instruction cycle clock.
Or for something physically tiny, a 8 pin PIC, eg. 16F18313, 32MHz, 3.5K Flash
Some Arduinos / arduino compatible devices are very good performance-wise, but remember it's a brand name not a specific thing. Many are just a low end MCU on a PCB - but some are such as a 48MHz 32 bit ARM CPU..
Personally, I don't generally like arduinos for the exact reason so may people do like them - they are PCB modules, often large, which are great for experimentation but horrible for incorporating in to neat designs. I much prefer a bare IC for that.
Plus I am not yet sure about or confident with program or device security if using them in products, as there are so many different MCUs in use; PICs are totally proof against software extraction if the security bits are properly set. [At least, short of talking the silicon apart & using an SEM, etc..]
If you want an Arduino type MCU to play with, have a look at a Seeeduino Xiao - about £8, postage stamp size, direct USB programming and readily available on ebay etc., just use the Arduino IDE and add the Seeed library link from the device wiki page. That's one of the fast ARM based devices with plenty of RAM and flash memory.
Getting Started with Seeed Studio XIAO SAMD21
Or for PICs, get a PIKCIT 4 and MPLab X. The MCU needs a 6 (or 5) pin header or RJ12 socket adding to your board for connecting the PICKIT cable, with a resistor and decoupling cap generally being the minimum other components for the MCU to function.
There is a also the Raspberry Pi Pico; that's the same Arm M0 core as the Xiao, I believe, with a lot more I/O connections - but needs a different and weird IDE from the bit of info I've seen so far - building a gadget someone else designed using one.
It has nothing in common with other Raspberry Pi devices, other than the name - other Pi's are self-contained tiny PCs, in effect, with convenient I/O connections and able to run Linux.