...and the contradiction creeps back in. Well, which is it... anyone?

Turning off location in the settings does actually prevent OVI Maps from working - it tells you that it needs switching back on when you load it. If enabling it genuinely means that the N900 is constantly checking where you are then there needs to be some way added to disable that rather than all GPS completely.