The biggest impact you see from increasing RAM is the DECREASE in loading times. E.g. loading times of a map in a game like UT2k4, or the loading phase in WoW.
Actual gameplay? Not as significant, unless your hard drive was getting paged like crazy (which may have caused dropped frames or stuttering). If that wasn't the case, actual game play does not see as big an impact.