Fremont is definitely its own thing which can really charming, but covid + the natural aging process definitely hit them hard.
Just a decade ago Fremont was a kind of cultural retirement community for the professional class in their 30s and 40s with an older generation of artists and small business owners. But now it's a retirement community for a lot of people in their 40s and 50s with school-age kids, and that older generation are either dead, retired, or priced out.
It's about an hour walk to Capitol Hill from Fremont and the walk around Lake Union is pleasant most of the year, but not so much in the winter. Driving to Ballard is probably your best option for nightlife around now, which I admit is pretty hit or miss.
So yeah, your perspective makes sense to me. Seattle has "at least one" year round nightlife neighborhood, but you're right that it's nothing like NY or Berlin where you have both full transit coverage and multiple districts to choose from.