Non-singular black holes and the limiting curvature mechanism: a Hamiltonian perspective