I mean usually you need a good AWPer because AWPs give you openings, which is fundamental in CSGO. So the top 20 teams sign the best AWPers they can find to give them openings. That ties in with going aggressive, s1mple often goes aggressive but it works out for him most of the time due to him hitting his shots, same with Zywoo. Its been like that forever. Aggressive AWPs are the most popular kind of AWPers in top teams because they can usually give you the man advantage. And from a normal player standpoint it still has the same principle, if you have a guy on your team that goes aggressive and can hit his shots then most of the time give him an AWP.
Price always matters with all guns, high risk but high reward, it has the ability to break your entire economy but its one shot kill makes it worth it in some instances.
Also utility is the main way of dealing with them, if they have a strong position then smoke/molly him out of there. Its hard to look away from popflashes.
I agree 100% that AWPs are annoying, like I said I'm bad, but usually I can match or beat other players in my skill group with rifles. AWPs are a pain in the ass but a fundamental part of counter-strike.