This was my first thought. There’s a decent chance this is going to be way more simple to wire than OP imagines. Could also be way, way more complicated too. But a can light is your only possible true BIFL option