Wallets are pretty good about this now, and lots of redundancy and sanity-checking is built in, e.g., Coldcard will yell at you if your fee is too high, which is not so much about the fee itself, vs. you screwing up the tx somehow, often by manually dicking around with the change address bc you don't understand how btc transactions work. This used to happen all the time in the old days.

Point is, use good tools, don't screw around with stuff you don't deeply understand, and you'll be fine.