DEPR: Dropping nuisance columns in core.apply
Ref: https://github.com/pandas-dev/pandas/pull/41475, https://github.com/pandas-dev/pandas/issues/39993#issuecomment-926281200

To keep the API consistent between groupby / non-groupby UDF methods (apply, agg, transform), we should not allow silent failure in `core.apply`.

 - [ ] transform_dict_like #43743 
 - [ ] agg_list_like - #43741