Nearly all SBCs have been used as simple platforms to interact with extra peripherals. The idea that SBCs shouldn't support peripherals is new, and arguably pointless. Want a computer with no peripherals to just run code? Pay a VPS provider.
Single-board computers without any extensibility are primarily sold by Apple. Very different target audience and purpose.
Ultimately a Pi or other SBC is a pretty nice size for using as a dedicated and specialised device for lots of things. I've got one plugged into my boat to monitor boat related stats, I've got one that does logging and graphing of environmental stats around my house (and runs Octoprint). Both running SSDs, and though I could for sure run these services on a larger "proper" computer there's really no need to take the space and power.
Running one as a NAS would be pretty sweet because it would be pretty small compared to my smallest NAS which is a Dell Optiplex USFF machine (https://willj.net/posts/fitting-two-hard-drives-and-an-ssd-i...)
What purpose do you think it is? Why do you think people spend their cash on a Raspberry Pi or any other RPi clone?
Agree, except cameras are often more practical or flexible to buy separately.