RPi is a good option if one has less RAM requirements especially if you take into account the quality of the drivers and software support in general.
RPi can be a compelling option if you need lower power draw. It does take some effort to squeeze out power efficiency but if the requirement can't be handled by a microcontroller then it is the most convenient of-the-shelf option.
For everything, RPi isn't a very compelling option. Even for GPIO, during RPi shortage I started experimenting with just using STM32 dev boards connected via USB to a NUC or an old PC and it worked well. But I just prefer to use ESP8266 or ESP32 for those tasks most of the time. Bandwidth and latency of USB communication/wifi to the main device has been low enough for it not to be a concern for me and I recon outside of very specific robotics cases it won't be for most.
CSI port is quite nice though and not many great alternatives.