I like defense, and I find the most entertaining games to be the ones that are low scoring. I played baseball and hockey, and my preferred positions were pitcher and goalie. I'm not sure pitching is really defense; it has the element of denying the other team, but it also has a very aggressive element that requires action and not just denial. I love the mindset and approach of being a goalie. You're part of a team but still set apart, and you're the last line of defense. I also liked that people didn't usually want to play goalie; that perversely made it more appealing.
I never played football, but I think that might be the one exception where I'd prefer offense or at least have no preference. Safety appeals to me, but so does quarterback for the decision-making aspect.