My absolute favorite leave in-conditioner is from the Danish chain Matas.
It has that perfect textured balance of adding slip, yet grip to my hair. It makes it smooth and shiny, but also adds some hold that makes my hair easier to work with and put up.
It has a really nice and creamy, soapy kind of scent. Fresh and nice, really.
The product is relatively thick, but easy to distribute.
The pump gives out a good amount too. Not too little and not too much.