I’ve not seen slide out cameras for years, didn’t know it was still a thing… Not sure what punch hole cameras are (didn’t read it all).
I remember some old Nokia’s, where you slid the front, to expose the camera or music controls, there was the N90/N97 (can’t remember which) that had s camera mounted on the top of the phone which could be turned around and held like an old camcorder. For its day, it took quite a decent photo.
I remember Nokia even having a camera with OPTICAL focus, that didn’t last long.
Samsung phones which still had a flip design n rubbish camera, with an Arial, while Nokia dropped the stubby.
It’s strange how now, Nokia’s are rubbish, and Samsungs are brilliant (my opinion, the best overall).
I think the note 9 is as good as it can be today for a phone to be.