Reddit mentions of Mushrooms of the Redwood Coast: A Comprehensive Guide to the Fungi of Coastal Northern California

With all the recent taxonomic changes, that's fair.

For my region specifically, my recommendations are:

Mushrooms of the Pacific Northwest
and
Mushrooms of the Redwood Coast

Amazon links for anyone interested:

https://www.amazon.com/Mushrooms-Pacific-Northwest-Timber-Press/dp/0881929352

https://www.amazon.com/Mushrooms-Redwood-Coast-Comprehensive-California/dp/1607748177

All The Rain Promises and More

Mushrooms of the Pacific Northwest

Mushrooms Demystified This is an old book, while still useful it definitely needs updating.

The New Savory Wild Mushroom Also dated but made for the PNW

Mushrooms of the Redwood Coast: A Comprehensive Guide to the Fungi of Coastal Northern California

California Mushrooms: The Comprehensive Identification Guide

Far more important than books are internet sources. There is a list in the sidebar and Here. Keys to PNW fungi is by far the best location oriented source.

Oh, and if you're up in the Bay Area, you really ought to check out Mushrooms of the Redwood Coast; it was just released last year and is by far the best and most up-to-date mushroom hunting book for your region. It's also chock-full of beautiful color photos.

This is the book you want—Mushrooms of the Redwood Coast, 600 pages and co-written by a local kid.

For mushrooms in general (not specifically psychedelic ones) I recommend All That the Rain Promises and More by David Arora. If you like that then check out Mushrooms Demystified which is his famous tome. Two newer books with beautiful color photographs are Mushrooms of the Redwood Coast by Noah Siegel and Christian Schwarz, and California Mushrooms by Desjardin, Wood, and Stevens.

The best way though is to go foraging with someone who knows what they're doing. Check out MSSF or one of the other clubs in the area. If you join MSSF now, you can still get a spot on the Mendocino Woodlands camping trip, which is an absolute blast.