Noodle,
I used to be a 'big dog" person also but my mom got a dog like PKM's, named Oscar (Oscar Meyer Weiner....
)...I like the name Lincon MUCH better, haha
Anyhow, he is such a fun little guy, he's so amusing and trusting. He's just limp when you pick him up, I even nicknamed him Noodle (go fig) and it stuck. He's not "yappy" and he's got tons of character!
Don't give up! Maybe talk to your husband and have him get a big dog and you can get yourself a little noodle! Macaroni perhaps
My dog & Oscar/Noodle got along just fine even though mine was 4x his size. Oscar had the same size personality