With the current 8+ hours battery life, I only have it plugged in when I'm at my desk, so no risk of tripping over.
For me, the standard port overweights any other downside.
Still, I wouldn't want to discharge the battery if it's not needed as to save the cycles.
More annoyance comes from removing of the charging indicators that were on the magsafe port. The only clue is a small "ding" sound when it starts charging, but is easy to miss and won't happen in deep sleep. I've plugged in a laptop not noticing someone had unplugged the other end until the next morning my computer was still dead. It was also nice that you could see that amber charging light turn green so you knew it was charged without opening the lid and waking it up.
I'm shocked that Apple has not taken it upon themselves to ensure that there's a usable magnetic adapter for the USB-C port, under their brand or through a partner. I've tried a couple of third-party adapters that were utter failures. I hope somebody succeeds someday, preferably Apple or with Apple's blessing, because I would be very slow to try another third-party adapter otherwise.
These days I tend to use my laptop at my desk with external monitors, but the thing that worries me the most when I'm somewhere else is the yanking of the cable weakening the and/or reducing the reliability. I had to re-solder the power adaptor on an old Acer a few times, I don't think I've got the parts or skills (or time) to do that on a few year old Mac.
EDIT: If you talking about the connector inside your laptop, that is a different story.
Lots of people complain about missing MagSafe but I’ve never seen or heard of this actually happening. I’m sure it has happened but it just doesn’t seem like a big problem. For me, just in the past month I’ve had the usb charger yanked out by the cord multiple times by people and pets tripping over it while working from home, but the laptop is heavy enough that it doesn’t budge and the cable comes out cleanly.
The benefit of having a standard port now, being able to get monitor, power, and usb connected through one cable, or being able to use the usb-c charger to charge other devices when traveling, is well worth the change IMO. I also used to get little metal specks stuck in the MagSafe port, and then realize the laptop hasn’t been charging all day and have to clear it out and make sure the contacts were connected securely. I wasn’t a big fan of MagSafe at all.