I have a 64 GB iPhone and I’ve never come close to using all the storage space in many years. I’ve got thousands of photos and videos but like you say, they are automatically backed up to the cloud and then the local version is optimized away until I need it.