I was last out to Meat Cove 6-7 years ago and while the road was rough it was passable with a little caution. I think a trike would be ok for sure. There is a camping area at the end that has a magnificent view of cliffs and the water. There is an abrupt drop off that could be a PROBLEM if you tend to sleep walk.
I and two friends, all on trikes pulling trailers, made that run last Sept. Last 2 miles or so is dirt but was ok if you exercise caution. Of course, winter has happened since then so who knows. Meat cove is awesome view!!!