Yes, sport cars are fun to drive but this is also based on personal interest. Not everyone enjoy driving not to talk of sport cars which require much driving experience. Sport cars are designed in a different way compared to other cars.
Sport car give a better sense of control to the driver. Other cars are built in a way to be "safer" for the driver.
To enjoy driving a sport car, you need have much driving experience. If you a car person, sport cars are definitely fun to drive and you should try driving one soon.