Adding to the others' comments, there's a lot more that contributes to ride quality/harshness than springs. Shocks, tire construction/profile, unsprung weight (especially as you get stiffer), bushings, etc. But don't forget the most important factor... you. Everyone, even amongst the hard-core, has dissimilar tolerance levels. You'll just have to experiment and decide for yourself what's 'streetable'.