If you use the raspberry pi for homeservers or general compute (which I did/do sometimes) then the value proposition is quite poor regardless of pre AI prices unless you have very strict power requirements (in which case it probably fits the above use case already). The comparison with NUCs or mini PCs or laptop boards feels like it's a wrong comparison.
The chips used in PIs are repurposed Broadcom SOCs that have inferior bus speeds compared to a general purpose processor from intel or amd, even few generations old. For any general purpose computing these chips will always be slower. its like comparing apples and oranges. I never really understood why people did that.
Yeah, I don't disagree, but I would argue the Raspberry was always an applorange, and that's exactly what made it popular (together with the cheap price in the beginning, which made it basically an impulse buy). It brought people into microcontroller/embedded systems territory without having to actually deal with all of the stuff that made this so daunting. As you said, it is basically a normal Linux PC, just that it runs Arm and has GPIO. People who are really into electronics/embedded systems will use a proper microcontroller nowadays anyway, these have gotten so powerful and easy to use that there's really no reason for a Pi anymore. And on the other side, people who want a little server, a pi-hole, tailscale or octoprint or whatever, can just use an old used laptop/miniPC or similar. Since the Pi has gotten so expensive, I see basically no reason to get one anymore.
You can make such a dongle yourself from ~any MCU dev board, but there are also productized "USB GPIO breakout" adapter boards, e.g. the Adafruit MCP2221A.
The "Pi as an SBC with GPIOs" case now only makes sense if you really, really require the Pi's compactness and/or monolithic-ness (as might be the case for e.g. ruggedized embedded systems like robots.)
For many (maybe even most) people they do the same thing. Some just want a HTPC, basic desktop, or small server, no GPIO needed. Raspberry Pis were definitely cheaper early on because you could actually buy boards at or near MSRP, but over time the price rose and mini PCs became cheaper.
At first it was a blessing that the Raspberry Pi gained popularity as a general purpose computer, not just for education and embedded applications. The additional demand and popularity brought more money and development attention to the ecosystem.
At some point, which I could never really put my finger on, this general purpose computer popularity grew so large that the embedded systems and educational aspects of Raspberry Pi seemed almost forgotten by the mainstream users. At a local in-person meetup group it was a running theme for people to brag about how many Raspberry Pis they owned for different purposes and to boast about using them for applications where they didn’t really fit. In person I’ve heard more about Raspberry Pi NAS systems (where people are always disappointed with the performance and the price of forcing a Pi into this role) or Raspberry Pi Kubernetes clusters (which mostly sat idle and could have been replaced by a single PC with more RAM).
This reached such a critical mass that it almost seemed like the mainstream discussion forgot the original purpose of the Pi and thought it was literally just another computer, but small. Most people who tried to use it for this purpose were left slightly frustrated by how it didn’t perform like they wanted a computer to perform.
So now every discussion about Raspberry Pi attracts comments about how nobody should buy a Pi when you can buy a NUC or laptop or some other used piece of hardware and it’s so much “better”. This is the right advice for a lot of people who wanted a powerful general computer but bought a Pi instead, but it’s also furthering the misunderstanding of what the Pi is for.
The real advice is that everyone should be shopping for the right tool for the job. There are a lot of cool applications for the Pi where a NUC or old laptop or phone doesn’t make sense because you actually need the compact size, the low-level I/O, or some other feature. However anyone who can put a NUC or laptop side by side with a Raspberry Pi and consider them both viable options for their project probably shouldn’t have been looking at a single board computer to begin with.
There is a parallel situation happening with the “just buy an ESP32” arguments. If an ESP32 solves your problem, you also probably shouldn’t have been in the market for a Raspberry Pi.
I have mixed feelings on that.
For the longest time it was safe to say "just buy a Raspberry Pi" because they were cheap enough and powerful enough. If memory serves me correctly, the base board cost roughly the same as an Arduino Uno and offered considerably more. (Of course, there were cheaper Uno clones, but those depended upon support offered by official Arduino software development tools.)
While there are some projects which would only be possible with something like the Uno, there were far more projects that would only be possible with something like the Pi. So if you wanted to give generic go-to advice to a novice, the Pi it was.
The right advice is to use the right tool for the job, but that is something that a novice (or fly-by-night forum posters) aren't prepared to handle.
Of course, things change. There are more inexpensive microcontroller development boards and the microcontrollers themselves are much more powerful. While that doesn't negate the benefits of a Linux SBC, it does raise questions now that those SBCs are considerably more expensive.
Suddenly the Kodi and the GPIO crowd (Arduino, ESP8266, ESP32, etc.) could work with the same board.
A new era, like the IBM PC or the iPhone. Changed computing forever.
EDIT: like other commenters noted, it seems like it made the intel NUC a reality.
IMO, the problem with the Pi GPIO is that it's a collection of GPIO pins and low pin count buses for controlling peripherals, rather than a singular bus. The fact that it runs Linux without an RTOS monitor program or a sidecar of sorts adds to the problem.
Fantastic for one-off projects.
Nowadays they require cooling fans and cost absurd amounts considering the performance so there seems little point.
Most of my one off projects these days are now on microcontrollers.