You just described what I missed about the older software. Older software gives users control over sorting and show data in a tabular format. Modern software sorts data with an algorithm, with ads mixed in, and shows data in a card format, making it a lot less usable.
(I actually worked for one of such "better off as an .xls file" startup in the past, and its main competitor was an incumbent that sold the same stuff as an Excel extension. Trying to replace that with a React app is not a worthwhile use of life.)
Algorithms are fine. I'll happily apply the most advanced ones I can get. The problem is with who applies them to what - as you and GP said, it's about user control - or, currently, lack of.
Sending sqlite databases to the users which they can interact with using both sql and a viewer is where it's at.
Other options might be SQL Server Express or SQL Server Express LocalDB, the latter of which seems conceptually very much like SQLite within the MS ecosystem, and both of which are usable for production purposes at no cost within the technical limitations that differentiate them from paid editions.
We are not front-end people, so the app is built with the expectation that people will be doing their filtering, searching and using the intelligence we provide, but in their home turf (excel).
Our app also lets users "track" certain events, and we do not use push notifications, rather we respect our user's attention and email them a short summary, and link to a csv that they can use!
I'm old and tend to agree, but I suspect this is similar to "you used to have a knob on the TV that showed the channel it's on".
A lot of change is for the better, but quite a lot is a regression.
I have access to around 1000 "channels", if you include live broadcasts and network-like apps. How exactly were old TVs better at helping navigate that?
With digital broadcast TV and cable whenever you switch to a different carrier there is a long delay (at least 0.5 sec) for the radio and the rest of the processing train to sync up. With streaming you have to do multiple network round trips to establish a stream. Either way you don't have the immediacy that old TVs had.
The question of UI in modern TV is interesting. 15 years ago the 500 channel problem looked difficult, my impression was that Comcast Xfinity (2010) was the first really good STB interface for the digital age.
I have a NVIDIA Shield which has an Android TV interface that convincingly makes FAST services like Pluto, Plex and Tubi look like linear TV on an STB. What you find though is that going "back" from one of those channels can put you, disorientingly, in the app for those channels, and also that you can usually navigate better if you start out with the FAST app (and have a more consistent experience watching FAST on a computer, tablet or XBOX) Except for those things which, for some reason, are easy to find in Android TV but hard in the app.
Knowing what was on 500 channels may have been difficult, but that's equally difficult now. The problem of navigating 500 channels was solved more than 25 years ago by remote controls that had numpad buttons on them. You navigate to channel 351 by pressing buttons 3, 5, and 1 in sequence.
After the digital switchover, there was now a set-top box, and electronic program guide and three-figure channel numbers thrown into the mix, as well as stateful aspect such as whether the TV was set to AV or still trying to use its now-obsolete tuner.
For someone with poor eyesight, limited feeling in his fingers and limited ability (and admittedly willingness, too) to build a mental model of how the menus worked and how they can be navigated, it spelled the end of his unsupervised access to TV.
The big difference for me between database-query-driven and algorithmically-driven is that the latter makes it very hard to know when you've completed an exhaustive search. Indeed for the likes of meta and tiktok that's a feature, not a bug, since their goal is to keep you engaged and plugged into "their" content forever.
You can avoid this by using the physical power button, which is conveniently located behind the TV. It will still take forever to turn on, but there's no ambiguity over whether you've started the process.
I still have trouble believing the device was allowed to reach customers in this state.
There are people out there that will pay. The issue is not that there isn't willing consumers to pay for it, it's that you're undiscoverable until word-of-mouth builds around your product among people(like those in this very thread) know and talk about your product going against the grain.
Look at defunct sites like Nextag that were moderately useful in the space-- they had free and paid placements. They were steadily growing search visibility until Google started pushing their own product (Froogle, free product listings in 2014ish) and Nextag suddenly "violated Google's policies" and lost 90%+ of their traffic rather quickly (probably 1MM daily visits to under 10k basically overnight). Google shopping technically offers "free product listing placement", hidden well below the ads-- likely as a defense to anti-trust on monopolization of that specific space.
Brickseek and CamelCamelCamel are the two most successful/long lived tools in the space-- and they grew their visibility from the now defunct but once huge deal site FatWallet and SlickDeals. Walled garden subreddits frequently disallow posting of specific tools, so it makes organic growth super challenging-- given that pretty much all commercial queries start with Google or Amazon.
Everything from Voidtools is a dialog window, accepts patterns and is really fast.
Here is what I mean. Photos apps used to let you search through your photos using filters.
The same kinds of things are happening on the web which already happened to apps (desktop and mobile).
In the modern world, some marketing company wants to tell YOU which of YOUR photos you wanted, so they can sell you some prints, harvest your data, or something.
I would like any apps that have to do with collections of files, photos, music, etc to be more of a deterministic DATABASE and less of a nondeterministic algorithm.