PowieT

This widget plugin will display a list of posts or pages.
<ul>
<li>Displays posts/pages.</li>
<li>Change sort order.</li>
<li>Display/hide created or updated date.</li>
<li>Include / exclude IDs</li>
</ul>

Powie's Page Cloud Widget

This widget plugin will display a list of posts or pages.

Justin Tadlock

The Query Posts widget was written to allow users that don’t know their way around PHP to easily show posts in any way they’d like. It’s like having a cool WordPress developer as a friend ready to do your bidding. Seriously.
The widget has over 40 options to choose from. You can list posts by category, tag, custom taxonomies, author, date, time, name, or anything you can imagine. You can choose to show the full content, excerpts, or even a simple list. You can order the posts in all sorts of ways. Oh, and you can even show pages.
This is the widget that keeps users out of the code and gives them the ability to display items on their site how they want.

Query Posts

A WordPress widget that gives you unlimited control over showing posts and pages.

Powie's Page Cloud Widget vs Query Posts