+1 that kill leto's with an ng bow archer quest made me go dagger and i love my Abyss Walker . but instead of looking for a tree on final quest it should be kill a raid boss :)
It's more easy to finish 2nd class transfer quest than you think: you use your normal bow for bringing down Serpent's health and when you are about to finish it you equip the NG ( required by the quest) bow. Problem solved. :p
And, no, I don't agree archers are "royally screwed". They will need to kite a little more, or --some of them-- they will eventually have to learn doing it. That's all.