I'm also a light rider who tried the Megneg because I was looking for better small bump. I didn't really like it either. Sure, it gives you a better off the top feel, when you push down on the saddle with your hands... But when actually riding the bike, I don't think I ever really noticed better small bump compliance. On my frame it also made the mid stroke a bit too harsh. In the end I was riding it full of negative spacers with close to the same pressure as with the standard air can, so I didn't see the point in using it anymore. I like to think of the Megneg as riding a standard air can with higher pressures and "forced sag".
This is just my opinion/experience, but I also found that chasing small bump compliance/off the top feel endlessly is a bit pointless. No matter how smooth your suspension is, on smaller bumps the tyres are doing most of the work anyways. IMO sorting out the mid stroke, end stroke, and damping is far more important and makes a much bigger difference. But that's just my opinion again.
