My home system is basically set up the way you're wanting yours to work.
You can get #1, #2, #3 done pretty easily.
#2 is gonna work 3-10 seconds after the fact, but you can definitely get it working.
You need a working BI and CodeProject.AI (I prefer run it in Docker in Linux). Once you get...