Well decided to give SP1 installation another shot this evening and in the end it was successful though I received the same fatal error C0190001 when applying update 484 of 97612 (bfsvc.exe)
This time however I chose to go the f8 route after the hard reboot to boot into safe mode. The screen showed files loading and it froze for quite awhile but then rebooted on its own and proceeded to boot as normal. When I got to my desktop I had the dialogue box that confirmed SP1 was installed successfully.
Not exactly a graceful update but I got there.