I also hate the feeling of product in my hair! What's worked for me is to actually read the suggested number of pumps/squirts and go from there, and if there arent any, for leave in conditioner sprays I start with 4 and go from there, trying 1 more each time I blow dry.
I have fine, straight/wavy hair that tangles easily and am growing out some bleach damage from two years ago under my current colour. So ive tried a lot!
I currently have on rotation:
Hair mask after washing: (leave it on for 20 minutes once a week then rinse) Garner Hair Food Papaya (I also hated the banana one, none of the others compare to the Papaya.
Note: I have tried basically every deep conditioner on the higher street and this is by far the best.
Leave in conditioner:
Currently trying out the Milk Shake Leave in Conditioner and its nice enough, works best if I put 4 pumps into my hand, rub hands together, run through hair, then repeat. Im pleased so far, been using it a few weeks.
others:
Shwarzkopf Professional Bonacure Moisture Kick spray conditoner (or any of the professional spray conditioners, you can get them on amazon. Need to shake them up then spray in. Very good - they have changed the formula on the Bonacure and it isnt as good as it used to be though, annoyingly.
Ouai Leave in conditioner:
Also very nice, but pricey
Kerastase Genesis Defense Thermique:
Technically a heat protectant but definitely doubles as a leave in. Its unfortunately, bloody excellent. Unfortunately, because its also expensive.
L'Oréal Paris Elvive Extraordinary Oil - use this every day, one pump and then run it through mid lengths to ends gently (dont tug, your hair will gently untangle as more oil gets worked through) love this stuff and its the only hair oil that rivals the Kerastase Elixir Ultime for me (which is unfortunately also bloody excellent and pricey, but I think the L'Oréal does a great job at challenging it, and I've tried a lot of oils)