Every couple of weeks I'll start a meeting with camera on for a minute or so just to say 'hello' to some folks, let them see I'm still 'here' in some sense, then camera off (usually). It feels useful to have some initial face/camera time to get a sense of the other person, but again, it's not something I generally routinely will leave on.
I had a period of a month or so last year where I moved to a Mac mini and... there's no camera. I didn't have a working webcam at all laying around, and it took me a month to bother to get a new one. No one missed anything of value by not seeing my face during that time. :)
Over the last 5-6 years, it's only been a noted issue with a handful of folks, and never been a deal breaker. The compromise is 'on' now and then for the start of a meeting. There's a humanizing aspect which is easy to lose sight of, but in most meetings, it's typically not that useful anyway. When there's more than a handful of folks, not all camera boxes can be see (too small, too many), and if/when you're working with a smaller group, there's usually much more value in sharing a document/editor/whatever.