I've been doing that. (building filters and LNAs and various antennas)
And its true, for many applications the RTLSDR is "good enough". A few years ago, it would have taken a rack full of hardware to receive 24-1700 MHz in any fashion. Also, the direct sampling, although a bit of work to get going, is an amazing extension of the functionality to lower frequencies the hardware was never supposed to be able to receive.
The RTL's low price makes it very compelling. And like perhaps even millions of other people, all around the world, (and that was definitely because they were so affordable) I've learned a lot using them.
I'm not challenging their usefulness. I'm just saying that they have their limitations.
The analogy you draw between a small image sensor and a larger one is a very good one, and there is no way around it, when you have a 3.1 megapizel camera's most high resolution image, it wont enlarge to be printable over a certain size. If you want to print out a large image and have it not be blurry, you need to invest in better cameras and better lenses.
Also, even if you have a great lens, the sensor matters a lot.
Similarly with the RTL, They have a lot of birdies (which vary from unit to unit quite a bit) and they can't receive really weak signals. They do inspire a lot of experimentation - to work around all these problems.
Which is probably my goal, learning. So in that respect they have been great.