OTWthemes

You can create a fully functional website using this widget. Check out the showcase. 
Drag & drop the widget in as many sidebars or custom widget areas as you like and build as many independent lists as you like. It is very easy to build any type of list you’d like. 
It works similar to SQL query but no coding knowledge is required! 
<a href="http://otwthemes.com/demos/smart-post-lists-light/?utm_source=wp.org&utm_medium=page&utm_content=demo&utm_campaign=spll" rel="nofollow ugc">Check out demo site</a>
<blockquote>
<a href="https://1.envato.market/c/1246358/275988/4415?subId1=spl&subId2=2020&subId3=https%3A%2F%2Fcodecanyon.net%2Fitem%2Fsmart-post-lists-widget-for-wordpress%2F935289&u=https%3A%2F%2Fcodecanyon.net%2Fitem%2Fsmart-post-lists-widget-for-wordpress%2F935289" rel="nofollow ugc">Upgrade to Pro Version</a> | 
 <a href="http://www.youtube.com/watch?v=4A8q7UQJzLg" rel="nofollow ugc">Video demonstration</a>.
</blockquote>
How it works
Go to your widgets section. Drag and Drop the widget in a sidebar(widget area) that you want your list to appear in. Fill in the form and click save. Here are the options you can choose from:
<ul>
<li>Select multiple categories and tags to list posts from.</li>
<li>Choose the number of posts to list and where to start listing from.</li>
<li>Order the list by: author, date created, date modified, post title.</li>
<li>Order to display posts: ascending, descending.</li>
<li>Select fields you want to show: title, date, excerpt, number of comments.</li>
<li>Select excerpt length in words</li>
<li>Choose to show image on: all posts, first only or none</li>
<li>Choose size of the image: thumb, medium, large</li>
<li>Choose image float: top of text, left of text, right of text</li>
</ul>
By filling a simple form this plugin will build an SQL SELECT query, return a result set and build html code based on it. The form controls select expression, where condition, order by expression, limit expression. 
No coding is required!
Showcase
You can create a fully functional website using this widget. Get some ideas at the <a href="http://otwthemes.com/demos/smart-post-lists-light/?utm_source=wp.org&utm_medium=page&utm_content=demo&utm_campaign=spll" rel="nofollow ugc">demo site</a>.
<ul>
<li>Sidebar examples</li>
<li>Footer examples</li>
<li>Blog examples</li>
<li>Portfolio example</li>
<li>Products example</li>
<li>Widgetized page</li>
</ul>
Customize front-end
By default the widget looks like all other widgets from the same sidebar (widget area) you drop it in. It has its own CSS file that overrides the default styles for your list elements. You can use that file to further customize the front-end outlook.
Get more of this plugin
Most themes for WordPress will come with default sidebars and a few footer areas where you can drop widgets in. If you want to have custom widget areas for instance in content areas of your pages and post, or any other area of your site:
<ul>
<li>Create your custom widget areas by using a plugin. It’s fast and easy.</li>
<li>Create your custom widget areas by little coding – advanced users.</li>
<li>Use an advanced theme with more widget areas defined.</li>
</ul>

Smart Post Lists Light

Create custom post lists based on options you choose from a form in a widget. Different types of lists, blog, portfolio, services pages. No coding.

Umang Bhanvadia

<ul>
<li>With the Help of this plugin, you can get post list of all custom post types along with default blog post type posts on your site.</li>
<li>You can get post list in two format, ListView and GridWiew.</li>
<li>There will be several more features like ordering posts, selected posts display, pagination etc.</li>
<li>You can modify default design by adding your own class in “Advanced” section.</li>
</ul>

UB Ultimate Post List

Plugin is great and useful. I used this plugin for listing post and it works as expected. Best of luck for future enhancement  !!!

Thanks

Very Useful plugin

Awesome Work

This plugin registers a block named "Ultimate Post List" which can be used for dynamic listing of selected posts of all custom post types and default post type "Post".

Smart Post Lists Light vs UB Ultimate Post List