In my experience, this depends a lot on the subreddits you are subscribed to. Even in that set, the general mood sometimes changes significantly over time, e.g. because moderators change, a flood of new people is coming in because of some trends (AI), or some reddit meta events (eg a post being bestoffed). Generally speaking, a few vocal asshles can spoil your subreddit and drag the overall sentiment down.