First thing's first, I'm not a suspension expert, and my car doesn't drive, so I have no direct experience with Z suspension. But I've been around here a while, so here's my take.
Your springs rates translate to 280lb/in and 224 lb/in. John C on HybridZ has said that anything over 300lb/in is pointless since at that point, the chassis starts flexing, at least a 240Z. Most people who have put together coilovers seem to go with something like 225/250 or 200/225, or something to that effect, not 280, but apparently all the mainstream coilover manufacturers seem to think that this combo of 4k/5k is good, I couldn't tell you why.
Shocks can also make a difference. My E30 has stiff suspension (310 front, 570 rear, IIRC), and I started out with Bilstein gas shocks, and recently switched to adjustable Konis. There was a noticeable difference in ride quality, and I haven't even messed with the settings on the Konis yet to see if I could improve it further. I have no idea what quality shocks you have there, but that could have something to do with it. I'm not sure if BC coilovers are really all that good, lots of people use them and like them, but I'm skeptical of their quality.
Lastly, it could just be you. I don't know what you were expecting it to ride like, but obviously it isn't going to ride anything like it did stock. You may have been expecting something that just wasn't realistic.