This fixes a regression introduced by ee7d047dd55a4b2338eb2d64f85b7d984b39812f ("ddraw: Always create surfaces with WINED3D_BIND_SHADER_RESOURCE if possible.").
C&C Red Alert 2 sets ddraw display mode to 8 bit, creates a surface with _PRIMARY caps only and doesn't tolerate output caps to have _SYSTEMMEMORY.
The patch here is a partial revert of blamed commit.