Tried it once with a noble family living in Willow Creek, but it didn't work out.
First of all, the game kept giving me female butlers even though I wanted an English gentleman for the lady of the house to get over her deceased husband with. I don't know how I finally got my male butler in the end, perhaps by cas.fulleditmoding the latest female one, but when I returned after leaving the family alone for a while, he had been replaced by a new butler, just like all the other service NPCs tend to get replaced after a while. No point in starting relationships of any kind with them, is there?
There was also always an overabundance of food in the house when the butler was there, I couldn't figure out how to stop him from cooking even more, and at some point, he vanished entirely. The End.