A lot depends on "what floats your boat" in terms of flying.
Some people get into aerobatics. If you like that, that is a whole lot of specialised training which you will need.
Some people like to go places ("touring"). That is why I learnt to fly. Going outside the UK is a big icing on the cake. You can do quite a lot of that VFR (I have some trip writeups
here) but having an IR helps a lot, and having an IMCR helps anyway no matter where you fly.
Some people just like going up into the sky. I suspect most of those give up fairly soon though. One needs to do interesting things - for the copious amounts of money which this activity costs.
One can also use it for utility / business travel. That can be tricky using light GA; there are many factors which limit the utility value in Europe (especially compared to the USA). But in the right circumstances it can work well.
A CPL is almost useless anyway, in Europe. It just enables you to do PPL instruction and get paid for it. A CPL/IR is the minimum useful professional qualification and even then only if you get a job with an outfit which has an AOC (with certain exceptions like a hired pilot for an aircraft owner).