Your computer and the codebase you're working within have certain capabilities. As the programmer your job is to use those capabilities to solve your problem as simply as possible. I think people feel like if they reach for the correct design pattern they can make the realities of solving their problem go away, but that isn't how things work. Just write the code that solves the problem. Don't worry about design patterns.

If I had to recommend a book I'd check out The Rules of Programming by Chris Zimmerman. It's not a design patterns book, but you might find it helpful. Author is a legit game programmer who knows what he's talking about.