This is so application dependent. Writing a white paper on the topic is on my to-do list, albeit a few pages down.
Sonoff - great for sprinkling around where the application is not very challenging. They are my go-to for closet ceilings. One is at the top of the basement stairs. The coin cell battery is a downside, though I have been getting over a year out of the original batteries. Oh, and they are as ugly as sin.
Hue - my favorite for outdoor (all 4 corners). Indoor ones are fine, but I don't have a great use case. Right now, I have these in our attic, mudroom, and garage. Common batteries and long life.
Bosch ISW-ZDL1-WP11G - the best for wide areas and pet tolerance. Uses something like 6 x AA batteries, so size is the obvious downfall. If you want inconspicuous, then this is not for you.
Availability is now sparse or expensive. These are in my "great room" (detects kitchen, dining room, and living room), my main hallway, my wife's office, in-law kitchen and our sunroom.
Visonic MP-840 K9 - my replacement for the Bosch. Smaller, but response is a step or two slower. Availability at good prices on eBay. CR-123A battery is presumably good for 5 years. These are in our in-law den and the bottom of the basement stairs.
3rd Reality - I have one on the shelf to test. I like the form factor and the asymmetrical detection zone (alter the vertical range by turning it upside down). As noted, common batteries. I could see these replacing Sonoff applications.
My absolute favorite indoor sensor is a hardwired Lutron MS-OPS5. If your switch location is roughly where you want to sense motion AND you just want it to trigger lights, then don't over-complicate matters. This is robust and fool-resistant. I have these in laundry and utility spaces.
My absolute favorite outdoor sensor is a hardwired RAB Stealth 360. Similar to above; it just works. It is a relay output, so you could feasibly use it along with a smart relay like Zen51. Over the garage right now and planning another at the back steps.