The camera is probably the least important thing on the phone for me, but yeah if photos are important to you then that might rule out the cheaper tiers of phones.
I hope that a few years down the line there will also be great midrange Motorola phones with GrapheneOS support. But they have to start somewhere.