This is something that I feel can be very useful and powerful for Wordpress sites, but I have no idea how to do it. It's basically a shortcode that would return a list of posts that match a query, and that list can be displayed several ways (controlled by classes, shortcode, I don't really know what's the best way).
For example, let's say I wanted to make a page with two sections on the page. The first section would be a list of posts that have the category "Sports" and the tags"Lakers" and "Finals". The second section would be a list of posts that have the cateogry "Music" and the tag "Features". So, I would enter the appropriate shortcode for it, and on the actual displayed page would be the matching lists. Wouldn't that be really useful? I think so.
The returned result will look like:
Lakers in the Finals (this is entered manually, we don't want the code controlling the title, just the generated list):
--post 1
--post 2
--post 3
Music featured posts
--post 1
--post 2
--post 3
--post 4
And we can use the styles already defined in the theme to show how the lists will be displayed. For example, maybe you want the list of posts to have the thumbnails show. Or medium-sized images shown. Or no images, just bullet symbols. Or thumbnail+excerpt. And so on.
I've been wanting to do this for a while. This would give us (me) a really cool way to create some nice looking static pages with content that gets automatically updated.