See reddit's r/solarDIY. There are a lot of setups like this, either for full house power or partial. I have a relatively big server in my basemeent that I power this way, for example, with a battery system that acts as both UPS and a "charge the battery from solar and run off inverter when possible". Something like an off-grid EG4 is popular among the reddit crew as a way to manage this; the device tries to run locally but accepts a shore power feed from the grid so if you need it you draw grid power. No grid tie involved.
Entirely based on your jurisdiction, but that kind of zero-export requires the same permits and connection fee as a full net metering in mine. You can't end run the process by just being sneaky, electrical work needs permits and they'll either make you take it out (!!) or bring it into full compliance.
As an example, my utility is one of those ones that requires a separate manual disconnect, even though the vast majority of all-in-one inverters have a built in disconnect. It doesn't make any sense and it's at least two grand in permit + equipment, but that's the rule.
Now you could pull particular items out of their grid. Just need the wires and panels to make sense. They would not care about that either. It is only if the panels are plugged into the grid they start to care. Downside is sometimes waiting for that battery to have enough juice to work. It goes faster than you think and some battery systems are decently expensive just by themselves, on top of the panels/inverters/controllers/install.
I'm not saying this is bad. I love a good workaround for onerous laws & fees, but random Internet commenters aren't the best at determining what workaround will or will not pass muster if a judge gets involved.
Like someone said in another recent thread: "U.S. law though is highly non-autistic and what you were trying to do is just as important as what you superficially did." https://news.ycombinator.com/item?id=49064242
You can do a whole home backup + solar panel input (aka ESS+PV) but it's much more expensive in parts and installation and is more complex. If you don't add grid interconnect it can be much cheaper as you can use "off-grid" parts (grid interconnect requires more expensive parts certified for certain standards).
But some jurisdictions may not allow cheaper "off-grid" parts/systems to be connected to the grid, even downstream. So an alternative would be to install a transfer switch, where you manually switch from the grid to off-grid. But then you literally have to choose whether you use the ESS+PV or the grid at any given time and manually throw a switch (you can't use grid to charge your system). And yes you can set this up for only specific circuits/appliances. Again it depends on your state and local laws.
AI can do most of the research for you. Keep a Git repo and add documentation and details to it over time, and you can build up an analysis of what works for you based on all available options, price comparisons, energy requirements, and local/state laws. It is unfortunately quite complicated because there are many options but not all will apply to your location. And before you do any of this, do a solar site survey to see if you can even reliably generate enough power from the sun!