I'm not sure exactly what made Ecto click for me, but once it did, it quickly became my favorite ORM/data mapper.

Have you read some of the Plataformatec blog posts about Ecto?