Have you considered a gravel bike as a compromise? The roads by me are terrible so I switched to a gravel bike for commuting. Not quite as fast as a road bike but much more comfortable!