I believe the important criterion is whether it falls in the category of "LIKELY to become energized".
Factors to be considered could include whether the isolated pipe is in the vicinity of a connection where a conductor is LIKELY to be exposed in a manner that would energize the pipe.
An 18" stub of copper connected to an instant electric heater at a sink could be considered likely to be energized, and the pipe, faucet, and a stainless steel sink constitute a system that should be bonded by the EGC that provides power to the heater.
The copper piping from a shower valve to the shower head and tub spout, served by non-conductive plastic pipes, or the supply to a toilet or a lavatory faucet, are not likely to become energized, and therefore, are not required to be bonded.
Bonding around the water heater in a metal/conductive water system is a different consideration. The water heater is an element of the water piping system that may insulate one part of the system from the other. The bonding is provided to ensure electrical continuity of the system. The same reasoning could apply to plastic filters and water meters.
On the other hand, bonding around a water heater that is connected to plastic pipe would be absurd. The EGC of the circuit supplying the heater fulfills the grounding/bonding requirement for that component.