"Sport tuned" usually means firmer springs, higher damping forces in the shock absorbers (or struts) and perhaps larger stabilizer bars and lower-profile tires. Sport-tuned suspensions are intended to reduce body motions like roll, pitch and float to improve steering response, handling in corners and road feel. More control and more fun while driving on winding roads is the goal.
The downside for people who treasure ride softness is that they generally result in a stiffer and noisier ride over bumps. So to answer your question directly, they typically feel more "bumpy."