Switch that is physically closed, and electrically opened
Yes they are called "Shunt trip release" modules. 

Typically you buy a switch and buy the release module - which attaches to the switch. The release module is a way to electrically flick the switch.

It is extremely common in the electrical industry, as they are used to electrically activate circuit breakers etc.

Google "shunt trip release" and you will easily find tonnes of products that do what you want.

They only draw power to switch the switch, and you can get them to open or close or both, while the manual switch still works fine.