Are attributes really that important in the end?
In many cases yes they matter. And its usually in fairly subtle ways. Having more points for con so your fort is higher or wisdom for your will save, etc etc. It means you don't have to make as many difficult choices as to where to take from to increase your chances at whatever your thing is. And it makes a huge difference for MAD characters.
To the OP, one thing to keep in mind is that the game is actually balanced around that set of stats you find 'unheroic'. 15 point buy is the default assumption of the Rise of the Runelords and all other APs. And that is worth noting.
Personally I have gone a different route, because I like the idea of making characters more well rounded and not have every non sorcerer/bard be a socialially innept misfit (Dumping Charisma), while not making it even easier for SAD characters. I do a 25 point buy, but cap on Ability scores after racial bonus at 17 at level 1. I have found it keeps the success rates about where it is supposed to be (at low levels, at high levels everything else starts to matter a lot more) and means you can make more well rounded characters if that's what you are looking for.