That all depends on what type of shooter you are. Are you the type that simply points the camera, shoots, & does not evaluate the scene before shooting and not process the photo after it is taken..... OR, are you the type of shooter / photographer that touches the screen precisely where you want the camera to focus and then adjust the exposure to control highlights and shadows, then process the photo to end up with a great photo? A great photograph really depends on how good of a photographer you are. The camera is just a tool, the photographer uses that tool to create a photograph.
I think the 11 pro / max is a fantastic camera and I’ve gotten many wonderful images from it. As a photographer, Ive taught myself to see how the camera sees and I usually adjust my camera based on the scene I’m about to capture. So to answer your question, yeah the camera is great and the hype is real. All of the photos you see advertised on apple’s website were taken by professionals, not amateurs.