Yes frame gen could theoretically bring a 30fps locked game up to generated 60fps. But most of these older games won't have the data required by frame gen (per pixel motion vectors), or even if they do have that data it can still be a lot of work for modders to add frame gen support.
AMD has a driver level version of frame generation that doesn't require the game engine to provide motion vectors, but it's much simpler and similar to TVs that have motion interpolation.