I've never had a fish who seemed to need my company, but some have definitely been more aware of/responsive to me than others. The various pairs of ocellaris clownfish I've kept have all acted like wiggly puppy dogs when they saw me, and followed me all over the tank (probably hoping for food!). My maroon clownfish's idea of interacting with me was to glare at me, and then attack. :lol: My pink skunks, though captive-bred like all the rest, were very skittish and fled whenever I approached the tank.
Other fish I've kept were either afraid of me or ignored me. The cardinals (Banggais, pajamas, threadfins) wanted nothing to do with me unless I was feeding them. The fangblennies were mellow and unafraid (the benefit of having venomous fangs, I suppose), but indifferent to me...same with the ORA mandarin that I briefly kept.
On the other hand my current fish, a CB orchid dottyback, is wary of me, but seems curious about me, too. Whenever I come up to the tank she appears and hovers in front of her favorite cave, staring straight at me. If I move she darts back into hiding, but after a few seconds she pops back out of one crevice or another to have another look, then hides, then reappears, etc. It's a different kind of interaction than I had with my clowns, but entertaining.