An API Node? Not a huge problem, although it could be critical to some apps that don't handle the failure well.
A witness node? That will destabilize the Hive network. A top 100 witness is not that big of a deal as they are only producing blocks every hour or so but we barely have 50 reliable witnesses if that. As you go up the ranks, you are depended on to produce blocks more frequently.
RE: Hive API Node for under $750 - Hive can scale at very low cost.