I can't tell you which controllers in which mode work how well, but I can confirm that a PC running Frets on Fire will play like Guitar Hero, like Rock Band or like a custom hybrid of the two with an old Guitar Hero guitar and a Rock Band 2 bass controller in its USB ports.
You may have some minor issues getting the controls set up, but it's five minutes' playing around to fix it, not a big deal.
If the effects control goes batshit on you, change the effect to killswitch and set killswitch volume to 90% and while it'll still be going like a privy door with the plague in town, you won't notice.