I used to fly a Twotter to Dunk Is. It's a half hour flight from Cairns over tropical rainforests and clear tropical seas.
We flew a BA 744 Captain once. He came up and said that we had the best job in the world and would happily swap it. (Although, he'd probably baulk at our pay)
To determine your career path you have to work out where you're going to work. In the US it is quite normal to go pistons-turbopop-jets. In the UK you can go straight to jets after flight school.
Turboprop operations will expose you to a lot of different situations, probably more hands on flying and you'll definitely be exposed to a lot more weather. All good stuff to cut your teeth on.
The main draw back of turboprops is the pay compared to jets.