You will probably get a similar ride with most road bikes over rough pavement because of the narrow tires. And on a smooth surface they will all seem like you are riding on glass. Certainly it's a much different ride than your hybrid bike.

The bike you test rode does have better components than the Sequoia Elite but if you are new to road cycling, as I am, it might be more bike than you need. Only you can answer that question.

The pain you spoke about might just be the fit of the bike. Was the seat higher than the handlebars? If so you were probably compensating for that downward angle by raising your head to get a better view of the road and causing your neck pain. Your body is in a much different position than it's in when riding your hybrid where the handlebars are noticeably higher than your seat, putting you in a much more upright position. It may take some getting used to but adjustments can always be made so that your seat and handlebars are level with each other which should make you more comfortable.

Don't know if your LBS carries the Sequoia but test ride it if you can. Then just go for the one that fits and feels better.