What kind of inspection? Just peaking through an attic access and shining the light around, or a detailed inspection? Is this to bid jobs, search and rescue, security, or to check on what work was accomplished that day?
Having spent a sizable portion of my working life in attics and crawl spaces, I suspect you want lots of lumens thinking a light can be set up in one place and you won’t have to carry it around. I had a coworker with a monster light and I hated every time we had to work together. One fixed light means big shadows since it can never light up around corners, behind things, or anything your body casts a shadow on. Any time the light is in your face it also makes it hard to see in that direction.
There is no substitute for a big headlamp and a couple of bright LED lights that can swivel from Milwaukee, makita, or dewalt if you need both hands working around a house without light. Shine the big spotlights onto the ceiling for an area light, or use a 360 degree floodlight with one of the giant batteries and a tripod to get it up high.
Every person likes something different. Milwaukee has a good selection of headlamps, neck lights, spots and floods - get one of each and see what you like. There is no one perfect light.