Overgrown juniper bushes
It's probably worth taking the extra trouble to dig them out altogether. My wife (she's more of a 'plant person' than I am) says that you seldom see other plants growing around junipers (they don't coexist all that well). In addition, whatever you choose to plant instead would probably appreciate not having all those roots in the way.
Hopefully the dirt will be loose enough to not make it especially difficult. You might be able to pry them up with something; perhaps a pick or ??? You'll get the hang of it. And if the dirt is hard as concrete, it will be a good time to do some soil improvement for whatever goes in their place.
As for 'no curb appeal', you are probably taking a good step toward correcting this! The best of luck in your new first home!
Ah yes, what to replace them with!? I recommend spending some time driving through some high-end neighborhoods. Or better yet--at your local botanical garden....see what's out there....take your time...do some learning. For example, azaleas look great--but are only at their best for a few weeks a year.
Most homeowners really aren't very imaginative when it comes to landscaping. The proof of this is the miles and miles of boring grass lawns with the same old border plantings. Some communities even go so far as to mandate this level of uniformity....e.g., requiring 75% bluegrass (and the like). To make matters worse, homeowners become enslaved to bluegrass, with weekly mowing and the like. There are plenty of alternatives, they're just "not done."
So I guess the trick is to find what you'd really like, then figure how to blend that (at least somewhat) into your neighborhood--after all, you don't want to be a laughing stock.
It sounds daunting, but what the heck, it's a long-term project, and it's all yours! So enjoy!
Again, the best of luck on your new home! "See" you on future postings!
"Wow factor"/HGTV--this is a good thing, sure, why not!?
4x4 with winch--sounds like you have a ready-made helper!
Lavender--great idea. Where we are (Colorado) you definitely see good alternatives sometimes. Thyme is also a great choice; my wife has several varieties of it in her garden.
White stone...you're right, that DOES sound rather boring. Perhaps when you're all moved in the neighbors'll get 'plant envy' and put in something interesting. This certainly happens; remodeling can be contagious!
And P.S., you're very welcome! Good luck and happy Move-in day!