Probably the most dramatic, was a little old lady, who new to tracing her ancestry. I found her grandmother listed in the 1880 census as "ad-daughter". Which translated to adopted of course. The lady slung her three ring binder at me, and accused me of lying to her as she stormed out. Bottom line, is if you get into this hobby far enough, I guarantee that there will be at least one bit of unpleasantry (if you are in that frame of mind).
Of the I have much more pleasure of seeing the people who I have helped. I helped one gentleman find his grandfather who he had been searching for off and on during his whole life. His comment was "I am dying of Luekemia, I had given up hope of finding out what happened to him". I teared up, and knew that my help was worthwhile.
I see that you are in Texas. That was once frontier country. Men once went into such territories with prostitutes following. Those prostitutes are in family trees. Has that turned up in your research?
My grandfather and my great-aunt were the only children of a lady who unfortunately died of early-onset Alzheimer's back in the days before anybody knew what it was. What's more, she was the youngest child of a very large family, and her parents and many of her oldest siblings were long dead by the time her children were of an age to take an interest in such things.
When my great-aunt was a very elderly lady, long after my grandfather had died, I was talking with her one day about genealogy, and she related all these facts to me and said rather plaintively that she didn't even know her grandfather's name. "Well, Aunt Ruth," I said, "I think I can fix that. Just give me a couple of weeks . . . ."
I hit the National and State Archives like a linebacker - I was between jobs and had plenty of time to spend. I came up with my great-grandfather's name, his birthplace, the names of his brothers and sisters and his wife's brothers and sisters, and the names of all his children. I found out just about every place he lived (or at least owned land) and where he was buried.
My great-aunt was SO happy -- she confirmed the names of some of his children and remembered visiting them in South Carolina when she was a very small girl. She said, "You've given me back my family!" I was glad I was able to do that favor for her before she died.