Personally I quite enjoy offshore flying, here on Canada's East coast we have enough bad weather to keep things interesting. Offshore in VFR weather all the time would get old quick I think, but throw in the odd mins or worse approach (and of course missing), some snow storms and low level jets...not too much, just enough to keep it interesting...
Without the poor weather, I could make due with being home everynight on a regular schedule while still making pretty good coin, not a bad ticket. Having 26 plus years in the industry, I no longer require the excitement bush flying entails, but I'm glad I have it in my back pocket, warm memories indeed. I do see alot of younger guys who get into offshore early on get bored, pining for some slinging on fires or whatnot, and I would recommend getting it well out of your system before moving into offshore.