GnomeWorks
Adventurer
actually isn't the 'small species with giant weapon' a significantly popular archetype?
I don't think I've encountered that personally, but that's anecdotal so not relevant. I will point to FF7's Cloud, though, as being indicative of some kind of "person wielding a weapon they really shouldn't be able to" archetype being a thing.
At which point a feat that allows you to do that, or a class that gets features to allow them to do so and focus on that (bear in mind I don't believe in multiclassing and so whatever potential issues would arise from that are, in my mind, irrelevant), would seem to be the best answer. That I'm a proponent of "everyone gets a feat at 1st level" (and thus enabling the concept for everyone) is certainly coloring that answer, though -- but then 5e24 seems to have also gone that route, so that might not be a relevant concern.
personally i don't love the need to make the biologically disinclined species any worse at a thing than the baseline set by the other general species capability
Dogs are not giraffes.
i'm happy just having the goliaths have their thing that makes them exceptional at strength-y things (though i don't think that ought to take the form of ASI boosts), so long as the halfling also get their things that make them better at stealth and other halfling-y things.
Giving races features and access to feats and other mechanics that allow them to lean into their kind's strengths makes as much sense to me as having general-access feats that let characters lean into archetypes and abilities that aren't their kind's typical strengths, and as such is a sensible thing.