Hm...I'm not really an aggressive rider, obviously, but what comes to mind are:
Specialized Amira
Trek Madone series (I'm not sure how aggressive the geometry is, though.)
Giant TCR Advanced W (not sure how "W" they are, since Giants have relatively long top tubes, but go ahead and test them)
Cannondale Super-six Women's
I only really know of the big 4 because that's what the shops near me carry. DBF's a Cannondale fanboy and would tell you to also look at the CAAD 10. It's aluminum (carbon fork), but he says he felt a real difference in the ride after moving to the higher-quality tubing in his Cannondale. (He has an R2000, and moved from a Giant OCR3.)