If you would like some suggestions comic wise as to what to read or not, let me know and I can suggest a few good books. I love talking comics, so ask away!
Green Arrow is an interesting character. As Oliver Queen he can be very political, and this is something the writers sometimes play with. He has a cool Robin Hood costume, which I always loved, but they do give him some stupid arrows sometimes IE: a boxing glove arrow, handcuff arrows, etc. Still, in the hands of a good writer Green Arrow is brilliant.
He made an appearance in Smallville for a while. They sort of kept to his costume design but made it a bit more modern day snazzy, which was OK. They also had him, for a costume ball, dressed up in the costume Green Arrow wore when first created, which I thought was nice.
Marvel Comics has Hawkeye, who also uses a bow and arrow. He is part of the Avengers. While I never really got into that character, I did love how he was written in The Ultimates, which is a great book.
I prefer Green Arrow though to Hawkeye.
New comic movie wise there are some great movies coming out based on some great existing characters, and some great new characters.