I don't consider myself a hardcore user, but I would happily buy a Pi with more than 4 GB.
For example, on a 1 GB Pi 3 browsers rarely use more than ~700 MB plus some VM, but this is misleading. They seem to use a strategy of never requesting more than a certain high percentage of the computer's RAM even though they could make use of more. Ask among users with 16 GB+ and they will tell you horror stories of browsers shamelessly grabbing 10 GB or more and rarely giving it back. They're either hoarding it (no really, Mozilla once admitted doing that), or can't free complete memory pages because of their not so sophisticated allocation strategies.
Firefox is about to encourage users to have more than four user content processes i.e. eight or so. That alone can add 800 MB.
Other use cases are e.g. editing medium size pictures, certain games and so on. My point being, just because you don't see much RAM use on existing Pi models doesn't mean more RAM would be useless. Thinking ahead, RAM usage will only increase because of lazy programmers. As they said in the old days: "What Intel giveth, Microsoft taketh away". And of course there are an increasing number of irrational 64 bit aficionados who think they just have to use Redis.
I already said it shortly after the launch: There will be those who want 4GB+ and those who never talk to their Pi except over SSH. You could have omitted the 2 GB version and people wouldn't have missed it.