Dash and Dakota (my parents' dogs) carry their tails like you describe, when they're excited. I think a lot of it just has to do with where their tail is set. Dash and Dakota's tails are set up high on the rump, so it's easy for them to swing their tails up above their backs.
Eve is the complete opposite, her tail is usually either straight out behind her, or tucked between her legs.