Usually, scene modes are just subject-specific versions of Auto mode. They bias settings such as aperture, shutter speed, ISO, drive mode, autofocus behavior, and JPEG processing to suit a portrait, landscape, sports, sunset, etc.

If you already understand exposure and prefer shooting RAW, they usually offer little benefit beyond convenience. In many cameras, part of the “look” from scene modes comes from JPEG processing, so creative control is reduced, and some cameras may switch to JPEG-only or RAW+JPEG when a scene mode is used.

The main exceptions are special computational modes such as Hand-held Twilight or Anti Motion Blur. Those can shoot a burst and combine frames in-camera to reduce noise, blur, or shake. You can sometimes replicate that manually in post, but not as quickly or as conveniently.

So: for normal portrait/landscape/sports shooting, scene modes are mostly redundant if you're comfortable setting the camera yourself. They’re most useful when you want speed, convenience, or a specific multi-shot in-camera feature.