I think this is the most important point (I remember coming to a similar conclusion some years ago), but now I think there are a couple of ways around this caveat (mostly applicable to business, but also of some use in personal relationships).

So, the problem with loving your work passionately you stop caring about what other people think of it, what is its (monetary) value to them.

First way: use your love as a hook to which all youd business is tied. E.g. you are eventually aiming at completing some big thing, and in reaching it you could make use of such-and-such services which a lot of people also would pay for.

Second way (now I think it's just a variation of the above one): use your career as a carrier that carries you to your goal. E.g. use your job to accumulate wealth to finance your work later and as a learning experience (you don't want to fail your beloved project, better fail 'with the cats' and be prepared).

Frankly, I have some experience strictly following these advice in personal relationships, the result is weird (unfinished story yet), so use at your own risk :) But in getting satisfaction from work, they do work.