It depends on each situation.
If you're trading your support killing their adc for their support killing your support, it's worth at all points in the game - even more so when it's late game and the enemy adc is doing well.
In general if you're ahead of the average and are getting shut down gold on the kill you dive for, and die to someone on the enemy team who is behind you and/or scales worse with gold than you, it is worth.
It's NOT worth when you're giving kill gold to someone who scales better with it than you, to someone who's already ahead and will be even farther ahead of your teammates now even if you caught up a bit, or when you're more important on the map to your team than the person you killed was to their team (e.g. Again late game, trading anyone for their adc is probably worth since the adc is the most important in terms of taking objectives late game when teamfights are won).
I guess one major exception is for an ace. If we're 3v1 at the enemy base, I'll gladly trade 2 for 1 just because our surviving member will end the game.