It's not just the tyre size that makes a difference, so does the construction. I've just gone back from 25mm to 23mm on one bike and it's made a whole lot of difference to the ride comfort.
I've been running my PlanetX Pro Carbon on 25.5mm Jack Brown Race tyres which were made for Rivendell by Panaracer and sold through PlanetX for a while and are as below (not my pic)
They should have been good with a folding bead and light weight, but were possibly the worst tyres I've used - harsh ride and just didn't seem to provide any cushioning effect against the local crap roads. Don't know if it was caused by a very stiff and short sidewall - couldn't even do a quick thumb test to check the pressure as there was no give - or a harder rubber on the tread.
I swapped them out for a pair of dirt cheap (£7 each when I purchased them a couple of years ago) 23mm Vittoria Zaffiros this morning and went for a quick test ride - what a revelation. No road buzz, smoothed everything out nicely and I found myself going for a longer ride to try out known crap roads to confirm the better ride.
I suspect that a softer and deeper rubber compound on the tread combined with a taller and more compliant sidewall construction has helped with the improved comfort despite the narrower width and 10psi higher pressure.