When working on a Drupal site for a client earlier today I had an odd problem.
The client wanted a page that lists downloadable files and has a little blurb about the downloads at the top, so I duly created a view that lists all published nodes of type 'Download' and sticks some HTML at the top.
The problem occurred when the client wanted to change the HTML header text. Views is very powerful and the interface used to edit them is fairly complex. Giving the client access to the views administration pages would probably result in more support phone calls than we'd get if we told the client to ask us to make these changes as required.
Still, if a client can't edit their own website, what is the point of a CMS?
In the middle of documenting the precise steps to follow to edit the correct view, I remembered that I can in fact use a piece of custom PHP code as header, and I can load anything at all that way. In this case, I can load a user-editable page and display the relevant part a the view header.
In the end, two lines of PHP made my problem go away. I created a Story and made a note of its node id, which was 39. In the view header, can I load this node via the node_load() API call and the display just the body:
<?php $h_node = node_load(39); print $h_node->body; ?>
All the client needs to do is edit node 39 via the normal WYSIWYG editor. Views is so powerful that it solves the problem of being too powerful :-)