Gloria Zhao

Opened #28199 with tests that may help us ensure this PR isn't changing specific behaviors. Marking this as draft as it depends on that one.

> Some thoughts about logging: > > After testing this on mainnet for a bit, I think it would be nice to be able to follow the fate of each...

Rebased but not all comments addressed yet, still working on it.

Note I know there's a "needs rebase" label but that's because I rebased on top of 28107

> Isn't this check a little bit later than ideal? Wouldn't it make more sense to check both maxfeerate and maxburnamount as part of `signrawtransactionwith*` and `walletprocesspsbt` so that you...

Rebased and fixed CI. This is in draft because I'm focusing on v3 stuff, can be reviewed for its approach.

Working on pulling the first 2 commits out into a separate PR.

Opened #29619 for the first 2 commits, moving this to draft.

rebased and added followups from #29619

Rebased for silent conflict with #28950