This emphasis on voice leading is often what makes the playing of these progressions so beautiful. Here's a progression similar to Dave Navarro's intro to "My Friends" by The Red Hot Chili Peppers. The fingerings for this are:
So what's that chord on the end? Why, it's our trusty Cadd9 chord. Here's yet another example of how the add9 chord can be used to create nice voice leading.