Those cabins are far forward, so if seas are rough and the ship is pitching then you'll certainly feel more motion there than at midships. I like the feeling of being at sea. Others are more prone to mal de mer.
I've never had a porthole/window cabin, so I can't tell how you'd like it or not. For me, personally, I would not. I want to go outside and breathe the fresh sea air, and it's more convenient to do it in just 3 steps rather than having to get dressed to go up topside. But that's just my preference.