Another aspect to consider is the difference between flying for fun and for a living. Whether it's photography, gardening, driving or even deer stalking the romance of it generally dies to be replaced with an 'it's a job' attitude. To be a professional pilot of either rotary or fixed wing means high standards of skill, aptitude, regular testing, earlies, lates, and long days, and all in often crap weather day in day out. There's no 'don't want to do the Forties field run today / don't want to do the Nice today cos the weather's poor thanks boss'. There's a big, big difference between flying as a PPL(H)/PPL(A) and a CPL/ATPL(H)/(A). The required training is hugely costly and you do really need some aptitude to get to the point where you are comfortable and competent doing an imc approach at night to a rig in a snowstorm or a Cat3 approach to scandinavian airport at night in a snowstorm.
It goes without saying that enthusiam is a prerequisite but before you commit you need to research the jobs market thoroughly. As you know the North Sea business is slack so there probably aren't many jobs up for grabs and aviation generally is tight at the moment. You wouldn't be the first to invest everything and get nowhere so do your research first. Fixed wing is probably the way to go for the best chance of a career but sounds like it's not what you want. I have thousands of hours in both rotary and fixed wing as both a past military pilot and a recently retired airline pilot. Rotary is more hands on, though I only did a little bit of civil freelance on Jet Rangers prior to an airline job so can't comment really on the current commercial rotary world, but fixed wing airline stuff offers a better career I suspect in terms of salary and prospects. At the moment lots of pilots/few jobs equals low starting salaries and pay for uniforms etc but these things are cyclic - when business picks up so do salaries and conditions and after all you'll be in this for a career not for five minutes so will end up well up the salary scales.
Professional flying is not 'tedious' at all, but can be routine and hard work (yes really!!). After all, rolling inverted at 35000' and pulling through to a steep dive doesn't really help the nervous punter in the back (although fun!) and is frowned upon really. If you want all your flying to be fun you'll probably need to pay for it yourself.