Most all of those bikes you are looking at with aero shaped seat posts are going to be the higher end road bikes. Though certainly bikes made specifically for time trials and triathlon will have aerodynamic tubes too. And aero forms are moving down into the lower cost tiers of road bikes as well.

The name road bike shouldn't imply that they should be a first choice for everyone that has the intention of riding on the road. Road bikes are intended to be for higher effort cycling and longer distances. A better bike for just riding a short distance will be the cruiser style bikes. Ones with very slack seat tubes and swept back bars.

Road bikes have that aesthetic look that draws many people to them even though they will be better served by a different bicycle type.