Questions about using views versus custom queries has come up a few times on this site. The problem is that the questions aren't a good fit for DA, as they fall in the Non-Constructive category.
However, I think this is an important topic and I am convinced that we can craft a question that is both constructive and worthy of canonization about the topic.
I have some ideas, but won't have time to craft anything for a few days.
Please vote if if you think this is a good idea, and add an answer if you have any ideas for starting points.