It won't be like Huawei P9 but it does have crucial manual settings like shutter speed and manual focus.

my experience...
- never use the full 23MP unless u need to crop your picture. the quality of a full 23 MP picture is actually so so only
- i find capturing in 2MP actually give very sharp and clear picture. but the picture size is very small la.
- i still recommend taking picture in 8MP, which is a balance between quality and size
- in most cases, manual mode with auto settings better than superior auto mode
- for best result, use manual mode and adjust all the settings accordingly (of course this require time and knowledge and not for everyone

I'm curious, why the Pixel XL?

I don't understand the craze/raves about that phone. Looks very ordinary to me, with standard specs.