Where to begin with this...
Faye is probably one of my best examples. She has little story relevance, much to my pleasure, but she was incredibly useful as a cleric on Alm's route, in addition to Silque.
A lot of Fates characters since I generally disliked their cast. Takumi comes to mind here.