I have been playing a no-sneak archer character for a while and I will soon have a choice as to what my end-game bow choice will be. I currently am using Zephyr, but have access to dwarven cross bows.
My decision comes down to 3 bows/crossbows. The dwarven crossbow, Auriel's Bow, or a Dragonbone bow. Auriel's bow fires the fastest of the three, and has the highest DPS as far as physical damage is concerned. The dwarven crossbow can be beaten by the dragonbone bow as though it has 2 more base damage, it has weaker ammunition. A dragonbone bow shooting elven arrows can match it. The dwarven crossbow does have a higher stagger chance per shot, and there isn't as large of a delay between target acquisition and firing. The dragonbone bow is slower than Auriel's bow, but has higher base damage and can be custom enchanted.
So, I'm kind of torn between the three weapons. Note that I do not plan to go crazy with smithing and enchanting exploits, and only plan to smith to legendary, and enchant without the whole crazy alchemy+enchanted item chain for insane enchantments.
Also remember that this is a no-sneak archer which means I do not take sneak shots and usually fight at mid to close range. I never even carry a backup melee weapon as I never need it. It's actually a lot of fun, and as time goes on I will have a massive health pool as I only raised stamina to 200, and then everything else goes to health.