It is completely useless currently. Being able to shove with Mage Hand is just stupid and picking up items is the most basic use for it and should have been implemented from the start.
It is only a cantrip, not a summoned extra party member. Out of your combat suggestions, the only one I think would make any sense would be indirectly tripping someone. This would require a series of actions to set up and usable rope though and the mage hand would be used to pull the rope, maybe tightening a noose around someone's leg or clotheslining someone. Even that might be pushing it a bit but I could see it working for a video game (also some DMs will allow this sort of thing without debating force and weight and all that math stuff.)