There's a little island in the Bahamas that has one main road. It goes all the way through town, twists a little bit, and ends in the most beautiful, old cemetery. It has graves from the 1800's, and it's on a bluff overlooking the ocean. It's the most peaceful, beautiful dead end I've ever seen! Literally!
On to the original question, the Silver Comet Trail in Atlanta is a 40-mile converted rail bike path. At one point, it joins up with a road on the back side of a cemetery. The only warning is that vehicles might be on the path for that short section. I've wondered what I would do if I came over the hill and saw a funeral, and I would probably walk past out of respect. But, the path is there, with the intention that all the people will be riding through that cemetary. edit: that being said, it is towards the end of the path that isn't used as frequently as other sections.