Alum rock park used to have a waterfall. Haven’t been there in decades.
I’ve never been there, but it could be even better hiking there now. From that park, you can now hike into Sierra Vista Open Space above it.