Jubie,
Welcome to the community. I'm a lurker (in that I don't post a lot), but I've been a hobbiest and making my own content and such since early 2009. I got my start with Poser 5 (which I got for free as part of a promotion), then upgraded (for real money) to Poser 7. Daz3D first offered their software in 2012 and I dabbled with it along with Poser until early 2018 where, like you, I had medical issues and found myself with a lot of time to play on my computer. I own both Poser and Daz3D (along with other softwares) and they have both have "pros" and "cons". I use them both and like them both. They are the majority of what you will see referenced here.
Since you're a newbie (your words), let me offer you some bits of guidance:
- Making videos, while cool, is a TON of work. Seriously, making them look good at all (even "barely acceptable") takes a lot of computer processing. If you try to jump right into that, you might burn yourself out on effort and frustration before you get too far, and that would be a shame since creating 3d content of any type (not just what's on this site) is a lot of fun.
- if you've never done this before, practice a bit with making characters, or even purchasing characters. That will let you get a feel for what you like and grow into it before you get to deep into money investment before you know what you really want to do.
- Daz3D is free software, but content costs money. Poser software costs money, but comes with a LOT of content out of the box. Poser also does not support the "Genesis" figure very well, which a lot of the nicer characters are made for (Genesis also supports clothing and props a lot better).
- Getting into animation itself is not cheap. Maya might be the way to go, but it's not free at all. Again, try Daz and/or Poser (I'd recommend Daz if you're truly starting from scratch) for a while then graduate into the more intense programs.
- I'm 100% certain that others here can provide better guidance. I tried to do the animation stuff a few years back and gave up in favor of doing stills in comic format (for comic creation, take a look at "Comic Life" at http://plasq.com/apps/comiclife/macwin/. You'll also need post-production, so either Photoshop (the full version is expensive, but you can find Photoshop Elements affordably) or Paint Shop Pro.
- Note that both Poser and Daz *do* have the ability to do animations. That will allow you to get a feel for how creating walking animations or more fun things like showering/bathing, or some of the romantic activities. Give that a shot...again you get to experiment without getting too deep into spending money, so that you'll know where to spend your budget most effectively. If nothing else, you can learn the concept of doing the animations there, then transpose what you learn into whatever animation software you eventually use (e.g. Maya or whatever).
- In my experience, this site, Renderosity, and Daz3d.com have the best content to get you started. There's lots of great character creators available and you can "mix & match" to make infinitely original looking characters. There's lots and lots of other sites that cater to different preferences. (My recommendation: don't go too crazy starting out). If you found your way here, you can follow the chain to other similar sites with no difficulty.
- One very minor chastisement in the wording of your question: be careful how you use the word "girls" rather than "women" here (or on any 3D content site or forum for that matter). I know you didn't mean anything by it, but the terms of service here seriously frown on posting anything even remotely hinting at anything that even alludes to an underage appearance of characters. This site, appropriately, will ban anyone that even asks where to obtain anything like that (even in 3d fantasy form). We simply don't go there. Again, I know that's not how you meant it, but just make sure to re-read your posts before sending them so nothing can be misconstrued.
As I mentioned earlier, there's others that can provide more advice to you, but this is what I recommend for a newbie just starting out: Daz3D; smoking good computer; content from Daz, Renderosity, and Renderotica; Photoshop/Paint Shop Pro; and Comic Life.
Best of luck, enjoy experimenting with the software, and (as you have done here) don't be afraid to ask.