I haven't used close-up filters in ages... but these things can be quite counter intuitive.
On extension tubes, I noticed that the wider the lens, the more magnification I get.
But using a magnification lens, they make the lens work normally (like you described... I just tried it with my digicam and the front element from an Ansco Viking)