Glad you had a successful trip yesterday.
There are quite a lot of Pain/Payn/Payne's buried at Bovey Tracey Parish Church. Registers are available on FMP with images. If you search Bovey Tracey Registers on FMP then I suggest you use wildcards for the surname to pick up all the various spelling variants of the Pain name. There are not a lot of results returned if you use Devon Burials accessed from the A-Z, select Bovey Tracey and use p* in the surname box.
This would be Bovey Tracey Parish Church of SS Peter, Paul & Thomas of Canterbury.
As Henry was buried 1817 it would not expect it to be in a Civil Cemetery as most did not open until a much later date.