How to create a SmartHome on a home server without net with RGB lighting?

Hello I would like to automate my house about 120 m2, 3 levels. I have an idea and a vision, however I am quite green in smart-home topics, so I would ask for advice and tips on which paths to follow to get the result I dream of and, as I do not know myself, I will describe the functionalists I would like to have and you more knowledgeable forum members will hopefully advise me in this endeavour .
Then let's get started !

I would like the whole SmartHome to run on an internal home server, all solutions that require constant internet access are out (I mean devices that lose their smart functionality after losing internet). All lighting is to be smart (all bulbs), in addition the lighting effect in the living room would look like this: https://www.youtube.com/watch?v=_qQ9npRY0wM is it possible to achieve such an effect with other bulbs than Philips Hue ? Also I would be interested in the option of voice control (lighting, dimming, changing the colour of the bulbs). I would like to control all the elements of the SmartHome via voice commands (Google assistant or other). In addition, I would like to have a sound system as well as a microphone in each room in order to play music, but also to make calls, e.g. via my phone (Android PocophoneF1) or an application just for this purpose (Google Voice/Skype/VoiP? [preferably cheaper ]). In addition to this, open/close/temperature/humidity sensors (multi-sensor?), air purifiers (Xiaomi most likely), in order to keep the air clean throughout the house, i.e. the upstairs breezes all purifiers on the upstairs turn off. I close the windows they turn on and continue their work. Temperature control (smart thermostat), i.e. I leave the house, the house will check that no one is home will lower the temperature by 2 degrees, it sees(geolocation), (remembers?) that I am coming back will turn up the temperature by 2 degrees. Plus smart locks, motion sensors, a camera maybe 2 and some small media centre server. Oh fridge, oven, SMART washing machine are already purchased, TV (most likely Philips because Ambilight) an open question.

I know I've rambled a bit and I'm writing incoherently, but I think some of you have understood what functionality I mean and now my questions:

Is it possible to assemble something like this?
What hardware and software should I choose?
Which manufacturers do you recommend in order to spend your money wisely? It will be quite a big expense, I know, I would like to get the best price/quality/possibility ratio.
Which solutions do you recommend?

As for implementation, I would like to introduce the smart home in stages as time and money allows ;p
1. purchase the necessary equipment for the entire smart home (hubs, WiFi routers, etc.) such I would call CORE
Then add on further components, i.e. lighting (bulb replacement, HUE etc) audio (speakers, microphones in rooms) and finally the rest i.e. locks, thermostat, motion sensors etc.
And a few words about my skills, I know something about electronics, a little less about programming but I am willing to learn However, if this is not enough, I also have a programmer and a specialist in networks to help me (he worked in CISCO somewhere, he knows how to switch on/off a router ).

Gentlemen and ladies, is it possible to create something like this?

Best regards and thanks for any help/suggestions .

As I do this sort of thing myself at home and at work, I can tell you that to make it cheap and good, you have to do it yourself and make it from cheap popular components. If you want, you can use off-the-shelf components from popular companies.
Any ESP-based device is best for this, as there is a multitude of choices at a low price with surprisingly high quality and stability. There is also a large selection of free software. However, such a system requires a lot of programming work and knowledge.
Everything you have written is possible. For voice control, unfortunately, you need the internet (unless you fight with Jasper).
With a bit of knowledge and skills in sifting through the depths of the Internet, you can integrate practically everything. This gets rid of a lot of applications and replaces it with one system. For example, the aforementioned Xiaomi Purifier can be integrated with Domoticz and not use a dedicated application at all.
Such possibilities are provided by open source systems such as Home Assistant, Domoticz, Supla, OpenHAB, etc.
For my part, I recommend Home Assistant, even though I use Domoticz myself. At the start Domoticz is much easier to learn, HA is more flexible and has, one could say, unlimited possibilities, but it can be troublesome at the beginning. I am just learning it myself.
A very cool thing to master for integration is Node-Red. With this tool, I am able to connect practically anything that sends any data or states.
So with Node-Red I have connected, for example, Integra, Xiaomi Purifier, Google Home, Milight lighting, Magic Home, Tasmota, Sonoff, etc. at my place.
One thing you need to know is that such a system will know how to service practically only you. And that is the only downside of such a solution.

Thank you for your replies !

@Erbit That's what I was talking about, that I don't quite know how to convey exactly what I think ;p I meant systems that after an internet failure (router goes down, technical work on the links whatever) e.g. Cloud solutions may lose functionality completely or may then have it limited. In that case these statements are not contradictory .

One correction about the internet and the inaccuracies associated with it. What I meant was that everything is supposed to work offline CHOOSE to make a particular Smart Home component work Generally I don't like to share my data and in this case the whole lot of it (sensors, cameras etc) with any other company at all with anyone ;p I just don't. Therefore a local server, and internet connectivity in special cases or at my command .

As for Ambilight, Fellow has seen prices for this solution ? Besides, I was looking at some reviews and the cheapest Chinese equivalents of HUE were better than them and almost six times cheaper while the Chinese equivalents of good quality for 1/3 of the price, were better in every way ANYWAY: The Philips HUE bulb after an electrical fault (e.g. power interruption) lost the previously set colour and had to be set again. The cheapest Chinese bulb did not do that ;p Therefore the idea of PHILIPS HUE - Yes, but the components certainly not Philips apart from the TV as to Ambilight I have no objections .

Well baaaa but Bill can afford such wonders I can't yet But maybe who knows....

And the equipment of a colleague such:
FRIDGE SAMSUNG RS68N8220B1
Electrolux EOB9S31WX SteamBoost
Samsung QuickDrive WD90N644OAW

What can they do and what kind of smart ? Honestly ? I have no idea ! But as soon as I find out I'll be happy to share. They were not specifically chosen to have a SMART function, rather it is in addition to other functions in which these appliances were most suited to me.

@xury

You are a home automation angel Yes, I thought someone who is in the subject would understand what I was trying to convey. So I understand you recommend Home Assistant + Node-Red + a lot of time and stubbornness to assimilate new knowledge and the possibilities are theoretically endless ? .
As for the fact that only I will be able to service it is no problem

One more question, can you give examples of some ready-made products from popular companies ?

Thanks a lot for this information, I suspect that you saved me a nice dozen if not several dozen hours of reading and browsing the internet Flying paw up

If anyone has any more suggestions, solutions they would like to propose, go ahead! Write .

I understand the concern of a colleague, but by education I am a technician ICT, so something there preparation and technical knowledge I have Programming and so I had to learn because every now and then I have somewhere to contact with the code, and as for the time I realize that it takes a lot of it, but I have it too much and in this house at least 5 years I will spend so I think that I will make it <br/span>.

Thanks for all the hints I'll get back to you if I have any progress/problems

@snoochie
I totally agree with kol xury about the possibility of doing your automation based on Home Assistant. This statement is important as it is the opinion of a home automation professional who is not urging you to go for KNX, Ampio, Fibaro etc. but suggests a budget solution with a lot of self work (and learning). As a hobbyist, I have also tested many expensive systems of so-called leading companies in several locations and, guided by my experience and practical knowledge, I would currently choose a solution for 270 PLN (to start with) as a basis for building an HA home automation system called ais-home (google it). This is the cost of 1 actuator e.g. in Fibaro. I keep my fingers crossed for you and best regards.