Dimitris,
hello, and welcome to the Forum.
You ask a who lot of questions, and the answers will be as varied as the people answering them.
But here's my penny's-worth;
I've used the Coronet twice in demo's and am not overly impressed by it, my chucks (standard M33 x 3.5mm thread) have trouble locking onto the headstock properly so of the 2 lathes you note, I'd go for the Record CL4, but I don't think that it would be long enough for you to turn Snooker/Pool Cue butts on, you might need to look closely at the between centre lengths and then subtract the length of chuck or drive centre and the tailstock live centre to actually get near to the 'usable' length.
But yes, they are both made in Sheffield, England.
Don't want to put you off or offer you more choices than you can imagine but you could also look at the Axminster Catalogue (
https://www.axminster.co.uk/shop-by-interest/woodturning), or the German Dictum (
https://www.dictum.com/en/turning-lathes-bagf) site. The Dictum site has a choice of 6 languages but not Greek I'm afraid, but it may be cheaper to have a Lathe transported from Germany than the UK.
From my experience, Ex Demo lathes don't normally come up for sale to the general public. I know a couple of professional turners who have managed to buy the one they demonstrated for the manufacturer, but Ex factory sales are unusual.
The fact that say you want to turn 'Both big, long and small creations' really means you are looking for a bigger lathe than either of those you have noted. Big items normally need a big motor to turn against your tool cutting action, both the Coronet and the CL4 have 750w (1HP) Motors. I'd recommend you look at 1500W (2HP) motors or even a 2kW motor lathe.
Personal Note:
As I am an (ex) pipe smoker (and I've still got them all put away safely), the pipe you made and show in your picture is absolutely wonderful.
Bryan