MiniJunkie

(discloser: I'm a middle aged nerd who knows a lot about painting models and miniatures and very little about videography) Hi folks, I'm hoping to get some help with a recommendation for the right lens to pick for my needs. I am using a Canon Rebel T6i. I have the basic starting lens it comes bundled with (EF-S 18-55mm IS STM?). What I'm hoping to do is shoot relatively high quality video of my "talking head sections", but also be able to get a really nice view/shot of my hands and miniatures while I'm painting (for tutorial videos). Example of my talking head clips that i'd like to see improved https://youtu.be/N52st5xgBo8 Example of what I'd like to film re: my miniature tutorials (this is not mine, just an example of what I'd like to aim for) https://youtu.be/5itM17RTshw?t=4m47s My friend who is into photography and filming recommended this lens: Canon EF 100mm f/2.8 Macro USM Lens Thing is...I can't really get it to work well for either application. And for filming my hands/painting, I think I can maybe see my knuckle, and the focus range seems super narrow so most of the subject matter seems blurry. I have a feeling this isn't quite the right lens for my needs... My budget would be in the 1K - 1500K range I think. I'd be super grateful for any tips or guidance you guys can give me, I'm really hoping to get my channel up and running with high quality video but struggling with the equipment setup.