Hey Giacomo:
Welcome to the Grady Family; I will tell you what I know and what I don't.
While I have never been on a 175 Spirit, any 17 foot boat has limitations no matter the brand. Do you have protected waters in the area where you'll be running the boat? If not, the 175 will not suit your needs; It's too small for open ocean use except on rare flat days.
If you have access to rivers, bays & protected waters, you'll have a blast in that boat. It will sip fuel, be simple to anchor at the beach, and be easy to dock & clean up afterword.
"Rough Water" is a subjective term. it means different things to different boaters. Anything over a 1 ft wind-driven chop will be considered rough for a Spirit 175. You can glide over open ocean groundswells if you have light winds on that day. Avoid navigating inlets on days with significant onshore swells during an ebb tide.