I often want a melee PC to move somewhere else.
The DM had a Gobliln attack the Fighter and a Bugbear attack the Wizard.
You bet I want the Fighter to move over to the Bugbear without most likely taking damage from the Goblin.
As for your ranged point, that point is the same regardless of how one rules the feat.
None of this has anything to do with niche builds. It has to do with interpretation of the feat.
Okay, so at the end of your turn you pushed the goblin back and went over to stand by your wizard. So? You're done with your turn the bugbear can continue to attack the wizard next round and as an added bonus the goblin can come over as well or use their shortbow to help kill the wizard. Heck, you've done the goblin a favor, he can now use his cunning to hide and potentially get advantage.
I've had this discussion before and I've never come up with many scenarios where the feat is worth much.
If my fighter shoves someone away, that just means they're free to move about the room. I
want them to pay a penalty (an opportunity attack) for moving to engage someone else. Occasionally I could knock someone over a cliff, but if that's a valid option I'd probably just sacrifice one of my melee attacks.
If my fighter knocks a monster prone, other PCs may be able to get advantage on their attacks but only if they go after my PC, before the prone target and are within 5 feet of the target when they attack. Ranged attacks will be at disadvantage. It's probably a wash tactically in a lot of cases. If I wanted to reliably give my buddies advantage, I'd be a barbarian.
If my fighter moves after knocking the monster prone, I provoke an opportunity attack. It will be at disadvantage of course, but still not a great idea.
What happens next?
- The monster stands and moves to attack my fighter. I took an opportunity attack for no reason.
- The monster stands and does a ranged attack (no disadvantage unless someone else is adjacent) against the target of their choice.
- The monster stands and closes with someone other than my fighter.
- The monster stands, but my fighter has moved too far away for it to engage. It simply attacks someone else. That someone else probably has a worse AC than I do because I'm the one with the shield.
- The monster stands, but my fighter has moved too far away for it to engage. There's no one else in movement range so it simply retreats, possibly behind full cover or to get allies.
None of these scenarios buys me anything, it just makes my fighter a worse tank.
A scenario where it might make sense?
- The creature I knock prone only has 30 ft movement or so.
- We're all in an open field and all other PCs are more than 15 feet away
- My PC had more than 15 feet of movement left on their turn
- The monster can't simply leave or go around a corner
- My buddy has pole-arm master and he hasn't used it yet and the monster has to approach them instead
So I guess it could happen if I have the movement and don't care about opportunity attacks?