Paul Hoffmann can reasonably be described as one of Scottish cricket's accidental heroes.

Yet the gusto with which the Australian swopped Queensland for Uddingston in 1997 and turned an initial holiday north of the Border into a 16-year love affair with Scotland helps to explain why this larger-than-life character became one of the most popular figures on the scene. All of which makes it doubly disappointing that "Hoffy" should have found himself on the dole during the winter – he lost his full-time groundsman's role at Bothwell Castle Policies – and it explains why he, his wife Lynette, and their three-year-old son Hayden are heading off Down Under in March, to start work on a new cafe/bakery venture.

Those of us who have had dealings with Hoffmann, who represented his adopted country 119 times in addition to becoming the most prolific bowler in the history of the Scottish National League and helping his club to secure three Scottish Cup triumphs, will appreciate the appeal that running a cafe might hold for the 43-year-old; this, after all, is the fellow who could hunt down tea-cakes and caramel wafers with the same passion he demonstrated against the best opponents. Yet, for all his natural joie de vivre, there was an understandable tristesse, lurking under the surface, about the circumstances which have conspired to send Hoffmann back to his native Rockhampton.

"It has been a frustrating winter, with Lynette having to work non-stop, while I searched for whatever jobs I could find, without much success," said Hoffmann. "We have to look at the bigger picture and I have a family to think about these days, so a part-time role at Uddingston wasn't an option. We weren't sure we could afford to move halfway across the world, but we have made the arrangements and, now, it's all systems go.

"Of course, I will be sad to be leaving Scotland, although I never imagined I would be here for as long as I have been. When I first arrived, in 1997, I was spending half the time here and half in Australia, but gradually, I fell in love with this country, then I met Lynette and gained the chance to play for Scotland. Things sort of mushroomed, once I received a call from [the governing body's former director of cricket] Jim Love and, a few weeks later, I was taking a five-for against the England Amateurs at Arundel. I never planned any of it, but I have absolutely no regrets about how it unfolded."

It wasn't a coincidence that Hoffmann's entrance happened at the same time as the most prosperous period in Scotland's history. By 2003, he had developed into a genuinely dangerous opponent, both penetrative and parsimonious on the local and international circuits. "It was huge for the Saltires to get into the Totesport League, because the boys needed more high-profile matches and we came out the blocks, with wins over Durham, Somerset and Lancashire in our first four games, and a few people in the team began thinking: 'Hang on, maybe these county lads aren't as good as they're often cracked up to be.'

"In the end, most of these sides gained revenge but, if you look back 10 years, it was definitely a few notches up. Rahul Dravid played for Scotland, we thrashed Ireland in the final of the World Cup qualifying tournament in 2005, and we had plenty of boys, from Dougie Brown to Gavin Hamilton, Ryan Watson to Craig Wright, and Colin Smith to Majid Haq, who were capable of giving anyone a run for their money.

"The trouble was there weren't many youngsters coming behind us. I'm honest enough to admit that, by the 2007 World Cup, some of us were a bit long in the tooth, and that was a watershed competition, because, whereas the Irish beat Pakistan and have kicked on ever since, we lost all our fixtures and the profile we had built up just vanished. I don't know why Kyle Coetzer wasn't picked for the [game against] West Indies, but it was an ageing squad, we didn't do ourselves justice, and we have struggled to regain sustained momentum ever since."

Hoffmann once locked horns in the Australian environs with such luminaries as Adam Gilchrist, Ricky Ponting and Glenn McGrath but has never harboured any illusions about the difficulties faced by part-time performers, particularly when they are pitted against tough-as-teak professionals. For many years, he combined cricket with plying his trade at Lloyds Bank, but the mounting demands that this placed on him eventually took its toll.

"I remember finishing work at the bank, rushing home and collecting my kit, then driving down to Worcester. The traffic was terrible and I didn't get to the hotel until after midnight, then we were pitched in against the county at New Road the next morning, before I drove back home that same night," said Hoffmann, who also suffered increasing injury problems. "On the evening before the 2011 Scottish Cup final, I was in agony, I could hardly move my shoulder, and I thought, 'I will just be a spectator tomorrow.' But, hey presto, with a couple of needles [cortisone injections], I was fine for the next 12 hours. It probably didn't do me a lot of good in the longer term but, when you are part of a side which is involved in a big final, you don't think about things like that."

Despite his decision to return to Australia, Hoffmann insisted he will keep in touch with his former confreres and expressed optimism about signs of recent progress. Having watched many of the new class receive full-time contracts from Cricket Scotland, he has no doubt what must happen next for Pete Steindl's personnel to make waves.

"The first thing they need is more matches against the ICC big guns, and more regular opportunities to take on Bangladesh, Zimbabwe and Ireland," said Hoffmann. "But it's a two-way process and the Scots have to work their backsides off to follow Ireland's lead and beat a Pakistan or an England on the global stage and make people sit up. Personally, I would be targeting the visit of the Aussies [in September] as a game which they have a realistic chance of winning. If Richie [Berrington] or Calum [MacLeod] or Kyle [Coetzer] gets going, there is no reason why they can't make a lot of runs. And, in the bowling stakes, Majid is better than any of the current Aussie spinners. In fact, if he was an Australian, I believe he would have racked up a string of Test caps by this stage of his career."

Hoffmann has never been a glory merchant. When I asked for his most prized wickets, he didn't highlight the trio of Pakistan scalps he claimed for just 22 runs in a 10-over spell in 2006. Instead, he plumped for those which helped engineer Scottish successes. "Getting [Eoin] Morgan out in the ICC final in Dublin was big because, even though he was young, it was vital that we removed him early," said Hoffmann. "The same applied to [Jonathan] Trott when the Saltires beat Warwickshire in the Totesport competition. The important wickets were the ones which changed the context of the game in our favour."

There are plenty tales of Hoffmann in this mould. He will be missed in Scotland, even as he and Lynette do their best to introduce Australia to the delights of the caramel wafer.