I think I found the ultimate security camera. Bought this camera after a friend of mine recommended this brand. He is a photographer and used some of their products in the past and seemed really happy with them. Also, after a few hours of research, this camera seemed the only one to have all the features I was looking for, so thought I should give it a try.
Just like on the specs, you get everything they claim. The camera has a built in battery with a high capacity so you shouldn't run out of power, no matter what. This is also guaranteed by the solar panel which you get together. Both of them are waterproof and suitable for outdoors, which is amazing.

When it comes to storage, you have a micro SD slot which supports up to 128GB or if you wish you can store your footage over their cloud service. Obviously you would have to pay a monthly fee.

But, what I like the most about it is the pan/tilt/zoom feature which allows you to remotely control from within the mobile app, a very large area. The footage is on 1080p so it's very clear, even on night vision. Another great feature is the PIR sensor which is optimised to reliably detect people and large pets, and you can also modify its sensitivity from within the app. The night vision is both black&white and colour thanks to the flood lights installed in the front of the camera.

The connectivity is through your wifi so if you are planning on buying more than one camera, when you install them, you need to make sure they are within your wifi range and they have a strong signal, otherwise they won't work properly. Or you can buy a wifi extender.

The app that controls the device is very user friendly, so easy to install for people that are less tech savvy. And you can basically control everything from within it. You can share the device with other people, you can check the battery charging level and modify the power saving settings. Modify the motion detection sensitivity. You can take screen shots or record videos whenever you want. You can even set time periods for when you want the camera to detect motion and record videos. So basically, everything you can think of is within that app.

The only downside I could find is that it is a bit pricy. I've used a few RING cameras in the past and they were really good and slightly cheaper. But none of them had all these features. So if you are looking for a security camera that has everything, and willing to pay the price for it, than this is probably the best choice.