RFC: Review and update OperatorController condition types and status update logic

[joelanford]

Similar to catalogd effort in operator-framework/catalogd#379 and the catalogd RFC https://docs.google.com/document/d/1Kg8ovX8d25OqGa5utwcKbX3nN3obBl2KIYJHYz6IlKU/edit

[everettraven]

RFC here: https://docs.google.com/document/d/1DAUsVjeT1PJgUrbBdQjJh9eCOesOdlEhxKpVoV1_7m4/edit?usp=sharing

[everettraven]

RFC closed as approved and issues created for the resulting work items. Closing this issue.