REF: remove BlockManager.set
xref #33052, #33332.

This touches several DataFrame/NDFrame methods.  Those methods need a refactor in part because the ones defined on NDFrame are only ever called for DataFrame.  Will refactor in follow-up.
updated to remove the need for `clear` kwarg, so we end up not needing to touch DataFrame methods at all thanks!