You can see the module in action on this page:
http://www.ventrian.com/Resources/Articles.aspx1) Each article has a unique article id, so it appears as though it is displayed on a separate page, but they all display on the same page that the module is installed on
2) Yes very search engine friendly
3) yes I've had no problem setting up google sitemaps
4) Adding an article is just like working with the Text / HTML module, easy
I would suggest you watch the video review on DNN Creative and also ask some questions over in the ventrian forum to confirm it's right for you.
Thanks,