Esker
Hero
Sure, but I see it two ways. Yes, you can't be good or effective in every situation for mechanical balance. But also, if you are in a situation in which you can't contribute at all, it becomes much less fun. This is doubly so because most core classes (before subclasses) seem to have both melee and ranged options available. Barbarian and Paladin seem to be the only exception to this, and sets up greater frustration for these characters if there is no way to close the distance.
Monks too (if we're talking before subclasses). But I guess at least they're DEX-based so can use a shortbow or light crossbow better than a typical paladin or barbarian.