I assume your talking free standing styles.
I use the lgb ‘station’ lights, single and double lamp versions. I like the ‘pools’ of light they shine downward, i like the design. I like too, the softer light of the yellow bulbs. I run mine at 12v. They work reliably outside, with the occasional bulb needing tightening.
I use the base, which doesnt really integrate into the platform, obviously. I imagine a motivated person could find a solution to this, either drilling a hole for the entire baseplate of the light so as to sit flush in a platform/concrete style baseplate, or, via surgery , cutting and just using the plug portion. The Lgb are robust and convenient.
Dept 56 and lemax, christmas village item makers, make a variety of led battery lights. I bought several of the ‘stadium’ flood lights for the engine house area. They are great, and far more durable than the pola g styrene models. I also bought the small ground level floods to light signs, building sides, fountains. Very affordable. I do not re-wire these 4.5v battery packs, as the wires are very thin, and, for me, too difficult to cut and reconnect. Ymmv. Only had these three years, and i allow them outside during spring summer fall. So far, pretty good life and battery life. One could use an in-line voltage converter.
I also bought some old metal marx 1;43 lionel/ tin plate style arched double arm lights. ‘MainSt.’metal sign attached, for help id-ing.
All metal, black structure, chrome light reflectors, a bit short, plain white bare round bulb , but i liked the style for a smaller suburban station.
If you can, find old Model Power g scale lights, both free standing and wall mount. These were affordable, high quality, a bit plain in design, oddly sized, some with ‘white’ instead of clear ‘glass’, but another option. Baseplates are not removable, as far as ive found. Posts are brass, lamp housings plastic. MP made a grossly over sized ‘coach’ style wall sconce which would work well if mounted on a pole or square post. Wiring elegantly would be a bit of work. I used a few on buildings. Theyre simply a bit too big, as sconces, imo.
Finally, Busch makes some beautifully shaped street lights, g scale, no baseplate. Charmingly’typical’. These might be the best candidate for a flush, integrated lamp. Otoh, there’s minimal attachment area. Fine for situations where they wont be bumped. Theyre very similar the the lgb street lamps, but a bit taller, and, more intricately detailed.
Sorry youll have to find photos.