Are you thinking of buying a house around Quarry road or an apartment? If a house (and there's plenty that are same price or cheaper than apartments) then I'd say go for the house on Quarry road. That's purely from an 'investment' point of view, like you said.
For reselling, you're market would be better - Cabra houses have gardens as well as schools, supermarket, parks etc all within walking distance. And the city is walking distance too. So you'll be aiming at the first time buyer or young family more than likely.
But can I also say - If you think yourself that Cabra is nicer, than go for Cabra. You'll be the one living there, and hopefully in X years time when you want to sell there'll be people looking to buy that would share the same view!