People who lived in a house with a burial plot on the property, what was that like? How did it affect your use of the property and ability to sell it?

I would not buy a property with known graves on it for sure. Though I live in the center of many cemeteries and find it peaceful.

As far as affecting the use of the property it really doesn't, the only legal requirement is that it be fenced to keep the cows off of the grave.

I have derived some benefit from having a grave on the grounds tho - When a nosy neighbor who I did not trust asked me why did I bury my husband at home I responded "So that he may more conveniently haunt my enemies." Result was magical! Previous annoyances with creepers, peepers and sightseeing fell off to about zero.

Resale value affected? Dunno, don't care.