I went through this last night after my water pump developed the typical crack in the housing. This was the second time mine has been replaced, but the first time for me to do it myself. I suspect this made it a little easier as I didn't run into many issues with the hoses, but that top bolt was definitely a pain. It took me 2.5-3 hours.
The real reason I came on here was to let others know that the CARQUEST water pump I purchased from Advance Auto actually came with an all aluminum housing, so no more worries about cracking. This was a very pleasant surprise, as their website picture still shows it with the plastic housing. They have it listed for $396, but when you get to the page they will pop-up an ad for 25% off if you purchase it online. So not a bad deal for $300...
https://shop.advanceautoparts.com/p/...322/10626270-P