“More megapixels is almost always better.” The very premise of this title is debatable. In regards to the average photography enthusiast, how is 100MP realistically better (and I stress realistically) than 20MP or even 12MP? By “most everyone loves that” do you mean “most pixel peepers”? The average person (type who uses a camera phone for snapshots, for example) could probably succeed very well with just 6MP to 8MP, maybe less (I printed good 8X10s with my 4MP Canon G3).
True, there’s cropping advantages to larger MP count, from which some photographers would greatly benefit, and I presume higher MPs allow for removal of the distorting anti-aliasing filter. And for those exceedingly rare people who print, let alone print very large, more megapixels are of value. And yes, if one is truly concerned about image quality, you should print, because for me, no computer monitor, 27” or not, aesthetically surpasses a print. I know others will disagree, and that’s perfectly OK, but that’s kind of the point when discussing “what most everyone loves”; it becomes a bit more complicated.
Anyway, whether necessary or not, MP count will continue to grow for marketing purposes if nothing else…the megapixel race never really died. But keep in mind that while an affordable 100MP sensor, or perhaps a one gigabyte sensor, sounds tantalizing, it would, as others have noted, also necessitate buying higher end lenses to truly capitalize on the resolution as well as demand more costly computer and storage options. And you better keep that camera still, real still.
So as 40MP becomes the average MP for hobby/pro cameras (is “prosumer” used anymore?), there’s still some folks who love their Nikon D700 or original Canon 5D, and for good reason.
As for me, I use Tri-X, so however that contentiously translates to MP count, it’s what I’m stuck with, and I’m very happy about that!
I'm not disagreeing with anything you wrote, just adding a little bit to the discussion.. However, with respect to the highlighted text, there's also hard resolution limit imposed by diffraction- look up "diffraction limited optics".

