Michael, this is just my 2 cents worth. I think its hard to pick just one, then hope it works. Once you have a clearer idea of what you want to do you can start to narrow down the best choice.
e.g. Im an ESP32 fan and currently do most of my projects on the ESP32 S3 16M Flash 8M PSRAM, I got here after hitting a few walls with the stock ESP32 WROOM. For me, the key thing was the ESP32 S3 has usb on chip, so you can start to connect to the real world as USB devices, eg. a keyboard/mouse.
the PSRAM become important as I started to work with some color TFT screen, and needed more continuous RAM for a full frame color buffer… But none of this may be a concern too your projects; as such different chips might offer better features, lower power etc.
I am really a big fan of selecting the chip for the project, rather then make the project work on a chip. Most basic projects will work on almost any controller.
GPIO and Port Types and count can be important. I like the ESP32 S3 Mini, much like the C3 Mini in form factor, but some of my projects need more pins.
e.g. If you are clocking out a bit stream for WS color leds.
I really want to stress, there is nothing wrong with the C3 and it can be cheaper then the S3 so a good choice if you don’t need the S3 features; My key point here is if you “do” need those features, then you need the chip that has them.
One thing I think may be important will be how you want to code for the device.
Im very much old school and code in C for most things (C++ sometimes). I tend to use the vendors IDE/Framework directly, but this can be a bigger learning curve.
If you head down the Arduino path, there are lots of libraries already written that to a large extent will abstract the actual controller you are using. The seem to try to make the library call style the same for all, then hide the actual vendor code needed, which can be good if you do need to change controllers.
Then, of course there is python. the Pico with Python seems to be popular.
After all that… I think if you know more about the actual work you want a controller to do, the more specific the better, will help narrow down the need. If you don’t really know until you get closer to build time, then you either have to go over the top, or be prepared to change later.