"Compact" often refers to race geometry (just that the front triangle is small relative to the overall frame size--usually meaning that the seat tube is short relative to the top tube, as compared with "standard" geometry). So, it won't necessarily mean that you will be more upright. That depends on top tube length relative to your reach. So, really any WSD road bike will tend to get you a short top tube length relative to overall fame size.