I am not sure why you would cite the demise of MQA to reject all forms of streaming. MQA was just one way to access reputed Hi Resolution Files (whether they were truly Hi Res is a different story). However even a service such as Tidal that adopted MQA still has the majority of its files in standard CD resolution.
Streaming versus CD is more of a lifestyle decision, because given the comparable investments in equipment, there isn’t that much difference in their replay. In your case, your limited bandwidth would make it difficult to get a good result from streaming.
I listen to both silver discs and to streamers. Its great to have files on a server that I can access from different rooms in the home. For example, Right now my wife unfortunately has Covid. Our bedroom is next to my listening room, and I spent last night in the basement bedroom. It was great to be able to pull up the CDs that I wanted to listen to from the server to a streamer in the downstairs system, and I sample new releases with the streaming services that I subscribe to.
You have point in that streaming does involve more hardware challenges than CD replay, which is beautifully uncomplicated by comparison. Nothing like relaxing by hitting plug and play on the CD player. Streamers are networking computers and therefore subject to all of the issues involved with computers. With MQA one needed new hardware, and that is a major stumbling block.
However Physical Media also has a history of demanding that the listener invest in new hardware and media. Remember SACD and DVD-A, and Blu Ray? What about the whole switch from lps to CDs? Or going back from mono lps to stereo lps? Or home taping with reel to reel vs cassette vs CD copying and ultimately burning to a hard drive?
Format changes are endemic to this hobby, and not just to streaming