I don't hate limited accounts, I think they are a great idea however the structure and setup for Windows is not helpful at all. I've run a limited account as my main account on my Mac for 2+ years now. I get asked to authenticate when I install programs (as it should be) but I have never had issues running the program once they were installed.
On Windows I install as admin (when necessary) and then have to go through a bunch of extra steps (turning on admin access to the limited account briefly, or making sure the directories accessed are properly shared, or dealing with some annoying messages when booting/running certain programs). This is where things are just wrong for Windows. Some of it is due to poor applications and some is due the the whole registry setup and bits and pieces of the program installed everywhere. Getting limited users up on Macs is light-years ahead of doing it on Windows. I've even had the "install for all users" options not work, since as nearly as I can figure out it only puts the Start Menu shortcut in the all users Start Menu and doesn't address the drive sharing, registry access issues.
I don't necessarily blame Windows or the Application developers for this flaw since both need to address it but it is definitely not a walk in the park to run as a limited user in Windows and even worse if you are the administrator trying to make sure everyone's programs work properly. I like it at home this way since if anyone needs to use our computers they are always up in the limited accounts so I don't have to worry about people installing anything, but for the computers I've done for my in-laws I don't ever try to set this up because of the headache it would be for supporting.
Personally I have not had problems with the limited accounts with different programs like you have. But I agree that the Apple implementation seems more straightforward. Suffice to say, that does not mean that you can't have an easy going time with the Windows limited accounts, or that you just can't do it at all as some people have suggested. We're now more than a bit off topic though.
It does not make sense to me why you would want to set up limited accounts for people in the first place (such as your in laws) if they won't be utilizing those accounts.
Anyway, an easy workaround is just DON'T use the limited accounts when you don't want to be limited. Have a guest account for guests, and a user account for users with all privileges. You'll have to sign in, but your settings will be unique and no one will mess with your stuff, and YOU can mess with your stuff as much as you want without having to sign off the limited account and then sign on the admin account.
Also, it is annoying that Windows places everything everywhere. But this is getting off topic. We aren't really debating whether mac is better than windows at this, just that it can be done in windows, and for the OPs purposes it is quite easy to set up and implement, contrary to what some posters have been suggesting.