Really nice. The only issues are if you have to go to Manhattan a lot. Your choices are basically the ferry which doesn't run all hours or you have to do a musical chairs of taking the light rail to the Hoboken PATH station and then taking the PATH. That's the reason I didn't end up there. It's too convoluted to easily get into the city if you don't take the ferry. Timing all those trains up is a pain and super inconsistent during non business hours. But the neighborhood is lovely.

If you have to work or spend a lot of time in Manhattan especially if you're there late I'd recommend Jersey City. It's slightly more expensive but the transit options are much better. There's PATH trains to both 6th Avenue (up to 33rd Street) and World Trade Center where you can easily hit a ton of lines in the city. Jersey City is also slightly easier to get in and out of if you have a car (not by much) and of course there's just way more there overall. Restaurants, shops, hotels, bars, JC is a big city.

As far as flooding yes it can be an issue. I don't know if it's an issue at Port imperial specifically as most of that development is post Sandy. But Edgewater floods for sure and Hoboken took it on the chin. But that entire drive up the river through Weehawken, Guttenberg, West NY and Edgewater, along the river is beautiful and it would be a great place to live all things considered. In a lot of ways you get a suburban lifestyle directly across from Manhattan.