I combined a few different views into one using Bernt Hansen's custom agenda as a starting point (http://doc.norang.ca/org-mode.html#CustomAgendaViews). It includes everything I need - schedule for today, a list of projects, stuck projects, etc... Typically I will just go by today's schedule, but it is invaluable having my list of projects on the same screen so I can just tab over in a separate buffer to the actual org file if I need more detail (or if I want to see notes for a given project).
Not the parent poster, but I have custom agendas too. The two I use the most are "Today" and "Weekly review". "Today" has the ordinary day agenda block, but sprinkled with habits tracking, as well as the separate list of NEXT actions, sorted by priority and complexity. The view is structured to answer the "What should I be doing right now?" very quickly.
The "Weekly review" is made for a (slightly tweaked) GTD review. It allows me to review all the finished tasks in one plays, which I archive or refile for future reference (this is to mitigate the downside of mixing TODOs with notes --- you might lose important info when you archive a DONE task). Next block reviews the tasks where I'm waiting on something or someone. I can update their status and close them if whatever I was waiting on has happened. Then there are new tasks from my inbox (org-capture) that I refile and assign priorities/schedules/deadlines too. Then there is the agenda for the next week, so I have a chance to plan my work and schedule more tasks if I have the capacity. Then there is the review of all the NEXT actions. Then there are the SOMEDAY tasks, which I review and occasionally promote to TODOs or NEXT actions.
I'm also tinkering with agenda views that give longer term perspective for project planning. However, I'm already running into the limitations of agenda views.
Most of it is inspired by Bernt Hansen's (cited by the OP) and Sacha Chua's configs, though they are doing even more sophisticated stuff at times.
I've been meaning to do an agenda view for weekly reviews for awhile, but my master view works well enough. What I'd really like is an agenda view that approximates a burn down chart and gives me a suggested velocity for next week (or some arbitrary period of time) based on the difference between my effort estimates and actual clocked-in time. A task aging view would also be nice to remind me about tasks on my list that have been idle for awhile so I can update them.
But alas, this is the beauty and curse of org mode. I could do this, but will the time investment really make me that much more productive? Maybe, but maybe not.
