The following was copied from the docs:
When to use SelfServicing
When the project targets a single database type.
When you are not using a distributed scenario like remoting or webservices.
When you need navigation through your object model in a databinding scenario and you want to load the data using lazy loading.
When you don't need to extend the framework.
When you like to have the persistence logic into the entity classes.
When you do not require fine grained database access control, like targeting per call another database.
When to use Adapter
When the project targets multiple database types or would be able to do that in the future.
When you are using a distributed scenario like remoting or webservices.
When you don't need lazy loading scenarios in relation traversals. You can still navigate relations but you have to fetch the data up-front.
When you need to extend the framework with derived classes.
When you like to see persistence logic as a 'service', which is offered by an external object (broker, adapter).
When you require fine grained database access control.
There was no need to use the Adapter model in the development of HnD, that's why for simplicity the SelfServicing model was used.
If that's your case especially in new projects. Then go for SelfServicing. If not then go for the Adapter.
Now for your current projects, I don't see a reason to move your current applications to SelfServicing, unless you have the time and you are willing to spend it that way.
BTW:
I always use the Adapter model, even in the simplest possible applications. Maybe that's because I'm used to it.Or maybe because I always take into consideration any possible changes in the future that will need the Adapter capabilities. (like porting to another database...etc)