What you're missing is that most compact cameras will use an electronic viewfinder, rather than an optical one, if they have a viewfinder at all. Apparently a lot of folks don't mind composing and shooting from an LCD screen on the back of the camera.

The Powershot G's viewfinder has several drawbacks. It can be blocked by an accessory tube. It only shows 85% of the scene. It has little to no shooting data displayed in it. It exhibits parallax.

An EVF, by comparison, using liveview can show you pretty much exactly what you're going to get, along with a live histogram, level, exposure simulation, focus peaking, manual focus assist, etc. etc. Sure, it's more of a power draw, and eye relief with glasses may be an issue, but it's quite a bit more functional for most folks.

The Powershot Gs have also mostly fallen out of favor as a "enthusiast compact" because of the small sensor size (1/1.7", roughly 5x crop). Cameras like the Sony RX-100 series, Panasonic's LX-100, and Canon's Powershot Gx X cameras, which have 1"-format (2.7x-2x crop) and larger sensors in them are now the more typical recommendations for that class of camera, and the ones with viewfinders sport EVFs.

The only popular current non-dSLR digital cameras that sport an optical/hybrid viewfinder are probably the Fuji X100 and X-Pro cameras, but that's more about simulating an old rangefinder experience, and they're much larger/bulkier/expensive than the old Powershot Gs.

An optical viewfinder was always a rare feature on compact digitals, and the Powershot Gs were the lone holdouts. Now that the Gs are gone in favor of the Gx Xs it's going to be hard to find one.

Personally, I'd say maybe it's time to go EVF and look at an LX-100 or G5X (which are pretty much the same size/weight, and also have M mode, RAW capability, and a flash hotshoe). Or give up the idea of a viewfinder altogether.