So i actually decided to move to no one from vodafone who i had issues with. Now getting 7 ping to 1.1.1.1 instead of 16 on vodafone, which is about what i'd probably hope for from Sheffield.
The service activation time was incredible, so because of issues trying to go to talktalk and them cancelling, i decided to issue termination to vodafone and wait until i lost service before ordering with no one.
03/11/23 - 1:00am lost vodafone service
03/11/23 - 9:22am put in order with no one (opted for no equipment)
03/11/23 - 9:22am online account was setup with pppoe details available
04/11/23 - 3:00am service provisioned and live
tldr - no one got my service live in 18 hours from start of order. Yet to see how speeds are during peak time but happy with ping so far