Yes and no. Back in the day having a tiny sbc for any type of small task at home made a ton of sense since they were so incredibly cheap. GPIO, while nice, remained a gimmick for the most part. Fast forward to the 2020's, yes SBC's have become pretty powerful. However their price has skyrocketed and availability is almost none. For the price of a raspberry pi(or less), I can get a second hand office mini atx with 16 gigs of ram, 500gb ssd, a 5-6-7-th gen quad core i5 and a good amount of USB's and video outputs. And although 4-5 years old, it is stupid fast in comparison to any pi. I still have a bunch of pi's. One is an ssh server from the outside world to my home network but that's all it does. For anything else, I have two similar mini pc's in the corner of my flat and they do a much better job than any pi. One is processing a ton of data from a subreddit I moderate, along with backups, a small ml model to quickly filter out crap and whatnot. The other hosts dozens of docker containers running self hosted stuff - time management, documents, backups and so on. And there is no denying that x86(with all it's horrors) will always offer a ton more than ARM. All of which is horrible news for the pi's.
There are some potential applications still for consumers. Namely something that recently came to my attention - the beepberry. They are currently out of stock but this is something I'd adore. Get Kali running on it, and I want two immediately: toss one in my car and one in my backpack. I cannot even begin to describe how useful this would be. Then again - kind of a niche problem which is a subset of a relatively small niche to begin with - consumer sbc.
Based on price/performance alone an 8GB RPi 4 doesn't make sense even in its own category--it can't compete with an Nvidia Jetson. But if you're doing a lot of Pi work then the more expensive models earn their keep as dev machines. (Multiple compiler threads can actually use that RAM, and there are situations where transpiling on a desktop can't help.)
There are some potential applications still for consumers. Namely something that recently came to my attention - the beepberry. They are currently out of stock but this is something I'd adore. Get Kali running on it, and I want two immediately: toss one in my car and one in my backpack. I cannot even begin to describe how useful this would be. Then again - kind of a niche problem which is a subset of a relatively small niche to begin with - consumer sbc.