I've been at a "passionate programmer" e-commerce company for over 10 years. Their definition of "passionate" (of which apparently there are many) is a developer who doesn't simply convert a request into code, but who will also think intelligently about the larger (difficult) business problem and focus on it. When your client says "Build me a proprietary streaming video server," the ordinary programmer starts taking specs for it, whereas the passionate one asks to learn about the business problem being solved. Then you learn that the video server is for playing instructional/motivational videos for the salespeople. So the real business problem is an unmotivated sales force, and a "video server" is not necessarily the only solution. Now you can have a discussion about other solutions.
I'm sure some readers will immediately jump up with counterexamples and pessimism... how the other person won't want to hear about your alternatives because they're threatened, etc. but I have been living this life now for 10+ years at the same mid-sized company and it's real. And yes, I am paid well for it, and so are my direct reports. And no, I rarely need to work evenings or weekends, and neither do my direct reports. And we all get free food. And the company is consistently profitable.
From all the vitriol I've been reading here today, I get the impression my company is extremely rare. Guess I'll stay for another 10!