I might be wrong but I believe there hasn't been too many games after Rogue Leader that have used this feature and was wondering why. Is it a developer's preference or is there some sort of bottleneck ...

This is just a wild guess.. but the nvidia demos where opengl demos and 3dmark is d3d.. possibly the geforce cannot? or does not have the driver support to do environmental bump mapping in direct 3d.