I suppose a lot depends on what you actually use the Mac for.
It certainly won't do it any harm, if as you say, the memory is cheap enough.
My limited view opinion is given that it's an older machine would possibly suggest it won't be a night and day improvement, so I'd probably not bother.