Remove pg_hint_plan code until more investigations are done

In &4968 we identified that while pg_hint_plan improves some query timings, it would create a support burden on the infrastructure team.

While we investigate other options, we should remove the code that already utilizes pg_hint_plan features for cleanup.