That's a weeping form of Norway Spruce - Picea abies 'Pendula' or a similar clone.
Hard to say what the result will be by limbing it up - as remaining branches above will continue to trend downward. The difficult answer is probably removing it entirely, since as a coniferous evergreen it will always be blocking light and the view.
Before you fire up the chainsaw, you might contact local landscape design firms, and see if anyone would want to buy/move it. These types of specimens are often pricey. There is a lot of difficulty to moving one that large, but sometimes people are willing to try if they have an interested customer. Don't expect to get paid much; it will take a team of people and equipment to dig/transport that tree. But, that's better than a serious basal pruning...
The "bent over so much" may be due to quirkiness of growing habit, or due to ice/snow loads in Boise winters. It isn't something you will be able to correct.
Good luck, whatever you choose. It is one of the hazards of inheriting an existing landscape.
