Shortly, she is good as SSR servants.
I only feel bad for her 1st skill has long CD. And on charge debuff to enemy (yeah I want Orion style NP). Otherwise everything is great. However you cannot except everything 100% perfect.
A general team is Nero Bride + Dual Tamamo (bond CE), or Nero Bride (Star Absorbtion) + 4060 Waver-Tamamo. She has decent supprotive skills which could be utilized in different direction: 3rd skill good for Caster supports, and 1st skill could be either to herself (NP spam), or Tamamo (more team-wide NP recycle).
On the other hand, why she is also a decent mixed dps-support? (1) we cannot expect too much to make her support as Merlin/Waver or even Hans level since they are top-tier. But compared with some SR such as Helena and Medea Lily/Iris, her skills are contained 3 directions (attack-defense-np) which is more versatile. (2) Her NP has 5 turn debuff to enemy which is decent enough. (3) Her 2nd skill could be utilized for some DPS servant like Gil/Kiritsugu/Archuria which is great for damaging enemy + generation more stars. So 2030 Bride is also a commonly seen. (4) You cannot expect every battle is made of single class enemy, particularly event farming, So Bride is good as 2nd DPS.
If we always say “why wont we just use dual Merlin + Gil to straightforward kill any enemy” or compare any servant with supportive skill to Merlin, then none of servants could be pair to that. Bride isnt top-tier, but still decent as SSR. I prefer DW push more servant like her or Bryn, rather than some OP servants make your gameplay eventually become boring.