Wow...really depends on what you're doing in Motion (i.e. HD video with multiple layers). But I've done Motion with 4GBs of RAM and didn't notice much of a slow down.
Of course, adding RAM won't hurt - just remember to install RAM evenly (ie. all the sticks be the same amount).