(San Diego, CA, USA)
I spent my adolescent years in the Ogden (UT) "metropolitan" area. There is a nice waterfall (I don't even know its name) in the cliffs above the city. We simply called it "Waterfall Canyon". The trailhead is behind St Benedict's Hospital, and the path climbs up Mt Ogden's face for probably the better part of an hour. The trail is mostly shaded in canyon growth, then opens into a small rocky area at the base of a cliff. The waterfall is a pretty vertical drop, I'm guessing 100 feet or more. The plume fans out near the base, as the water hits the cliff face. The plume is visible from across the valley, especially during spring run-off, if you know where to look. You can clamber over rocks to the top of the fall. Above the falls is another canyon area allegedly called Malan's Basin. So far as I know, the fall flows all year, but I haven't attempted the climb in the fall or winter months. Last time I was there was a few decades ago, so things may have changed.
Bridal Veil Falls, in Provo Canyon, is also picturesque - if not impressive by any other measure. There are numerous falls by this name, but this one looks as much like a bridal veil as any I've seen.