I use the http://www.inventua.com friendly urls solution and found that it does nice rendering of pages. And for future updating, will provide me with links that don't break because it doesn't use the tabid numbering - so you can rebuild or move your site.
It's not a module but a dll and web.config change and you can then have user friendly urls.
It does however, put a + in the spaces. I'm not sure how that affects SEO's. http://www.xd.com.au/free+skins.xd see what I mean. I know I've got custom extensions on the site, and while I've got a caching module working it's not doing quite as it should, a standard installation of the href exchanger changes your page extensions to have .aspx at the end of them. I think this is a clean solution.
http://www.zinc.com.au/who+we+are.aspx is an example of the standard installation of the href exchanger.
There are some downsides to this (isn't that the case for everything) If using the custom extension like I am - .xd it's got a little bit more overhead to display the pages, AND, if you have the wrong url, it's not quite as graceful and doesn't take you back to the home page like the standard dnn install does.
I know that Scott McCulloch has been working on the the friendly urls more and you can see how it behaves here - http://www.ventrian.com but that still uses the tabID - but is getting closer to being a really good solution.
And.. I don't know if you've looked on the latest builds under host/settings, there is more information about the behaviour of the Friendly urls which is displayed if you click the link.
I confess that perhaps there is more information out there that I'm not aware of, so maybe I'm behind the times a little, but I moved to the inventua solution back in DNN2 days when I had 3 months of horrible linking when I upgraded my site from dnn1 to dnn2, and, my first tab I put in on dnn1 was free skins, which, when I upgraded, would then go to an adminstrator tab as the host/admin tabs and pages grew and for three months was linked to the log viewer page or something like that. And then, I made a bigger mistake, by changing what the core tabs say (this was done by a core team member, who at the time didn't realise what the long term repercussions would be) I thought it would all be ok, but I had changed the order of the admin tab pages, and lost for 1 year, the update to DNN 3, didn't work because the scripts wouldn't fire with the tabID's no longer being what they were, it was just a horrible mess! And I learnt the hard way on what happens to popular pages in google and how they link to the wrong pages.
However, having set the friendly urls from inventua in dnn2, while I had to compltely rebuild my site, it's kept the integrity of the links and to me this has been the winning combination.
I hope this gives you some insight in this area.
Nina Meiers