If you say “hear, hear!” in response to someone’s speech, you are expressing enthusiastic approval by encouraging those around you to listen to what he or she is saying.
If you say “here, here!” you are expressing mild disapproval, and you are probably British and rather old-fashioned.
(If you say “there, there!” you are trying to comfort the person. English is strange.)