Add support for callables as worker callbacks
The existing usage of function name strings as worker callbacks are already callables. call_user_func() supports many other types which we might as well support.
Update the exeception message to take the additional possibilities into account.
Closes #3426366