What is it about aluminum needles that make your hands hurt? Do they get too heavy after awhile?
I really love knitting with rosewood. I personally find it to be smoother than the Brittany's. I love Brittany's but I don't knit very fast with them. I've never knit with Surina.
I would handle all three types, consider what you knit, and think about the smoothness of each pair. If you want DPN's, but are concerned with your stitches sliding off, then Brittany's might be the way to go. If you're worried about knitting too tightly and the yarn not sliding enough, then rosewood might be the right type of needle. You might also want to consider bamboo. Bamboo is lovely to knit with. Very smooth, and very light. I think they're a little stronger too, which is important with the smaller sizes.
Also, if you're accustomed to using straight needles, circulars might also ease the pain in your hands. I find it much more comfortable to knit with circulars, especially with larger projects, as the weight gets distributed more evenly.