Those of you who know WordPress inside and out have no problem coming up with custom queries to add content to your site. Even if you are not a WordPress developer, Query Wrangler can help you create new WP queries. You will be able to create WP queries as widgets and use shortcodes on your pages.
Query Wrangler supports most post and taxonomy data. You can use it to create custom galleries, list posts, and everything in between. Its UI is based on Drupal Views. You can try the plugin for free.